Dataset info
| Number of variables | 181 |
|---|---|
| Number of observations | 265 |
| Missing cells | 21158 (44.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 361.4 KiB |
| Average record size in memory | 1.4 KiB |
Variables types
| Numeric | 62 |
|---|---|
| Categorical | 20 |
| Boolean | 10 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 88 |
| Unsupported | 0 |
Warnings
coligada_mais_antiga_ativa has 189 (71.3%) missing values | Missing |
coligada_mais_antiga_baixada has constant value "nan" | Rejected |
coligada_mais_nova_ativa has 189 (71.3%) missing values | Missing |
coligada_mais_nova_baixada has constant value "nan" | Rejected |
de_indicador_telefone has constant value "BOA" | Rejected |
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
dt_situacao has a high cardinality: 129 distinct values | Warning |
empsetorcensitariofaixarendapopulacao has 48 (18.1%) missing values | Missing |
faturamento_est_coligados has 191 (72.1%) missing values | Missing |
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.97256) | Rejected |
fl_epp has constant value "False" | Rejected |
fl_matriz has constant value "True" | Rejected |
fl_me has constant value "False" | Rejected |
fl_mei has constant value "False" | Rejected |
fl_optante_simei has constant value "False" | Rejected |
fl_passivel_iss has constant value "True" | Rejected |
fl_st_especial has constant value "False" | Rejected |
grau_instrucao_macro_analfabeto has 201 (75.8%) missing values | Missing |
grau_instrucao_macro_desconhecido has constant value "nan" | Rejected |
grau_instrucao_macro_escolaridade_fundamental has 12 (4.5%) missing values | Missing |
grau_instrucao_macro_escolaridade_superior has 3 (1.1%) missing values | Missing |
idade_acima_de_58 has 8 (3.0%) missing values | Missing |
idade_ate_18 has 208 (78.5%) missing values | Missing |
idade_de_19_a_23 has 76 (28.7%) missing values | Missing |
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.93912) | Rejected |
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.91473) | Rejected |
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.93769) | Rejected |
idade_de_54_a_58 is highly correlated with idade_acima_de_58 (ρ = 0.95005) | Rejected |
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.99076) | Rejected |
idade_maxima_socios has 172 (64.9%) missing values | Missing |
idade_media_coligadas has 189 (71.3%) missing values | Missing |
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.99283) | Rejected |
idade_media_coligadas_baixadas has constant value "nan" | Rejected |
idade_media_socios has 172 (64.9%) missing values | Missing |
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) | Rejected |
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.90301) | Rejected |
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados (ρ = 0.94847) | Rejected |
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.95153) | Rejected |
max_filiais_coligados has 229 (86.4%) missing values | Missing |
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.93125) | Rejected |
max_vl_folha_coligados has 207 (78.1%) missing values | Missing |
max_vl_folha_coligados_gp has 206 (77.7%) missing values | Missing |
media_faturamento_est_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.90753) | Rejected |
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.94656) | Rejected |
media_filiais_coligados has 229 (86.4%) missing values | Missing |
media_funcionarios_coligados_gp has 4 (1.5%) zeros | Zeros |
media_funcionarios_coligados_gp has 202 (76.2%) missing values | Missing |
media_vl_folha_coligados has 207 (78.1%) missing values | Missing |
media_vl_folha_coligados_gp has 206 (77.7%) missing values | Missing |
min_faturamento_est_coligados has 191 (72.1%) missing values | Missing |
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.98448) | Rejected |
min_filiais_coligados has 229 (86.4%) missing values | Missing |
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.91607) | Rejected |
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.95675) | Rejected |
min_meses_servicos_all has 19 (7.2%) zeros | Zeros |
min_vl_folha_coligados is highly correlated with min_funcionarios_coligados_gp (ρ = 0.99898) | Rejected |
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.99917) | Rejected |
nm_meso_regiao has 24 (9.1%) missing values | Missing |
nm_micro_regiao has a high cardinality: 57 distinct values | Warning |
nm_micro_regiao has 24 (9.1%) missing values | Missing |
qt_admitidos_12meses has 162 (61.1%) zeros | Zeros |
qt_alteracao_socio_180d has constant value "nan" | Rejected |
qt_alteracao_socio_365d has constant value "nan" | Rejected |
qt_alteracao_socio_90d has constant value "nan" | Rejected |
qt_alteracao_socio_total has constant value "nan" | Rejected |
qt_art has 135 (50.9%) missing values | Missing |
qt_coligadas has 189 (71.3%) missing values | Missing |
qt_coligados is highly correlated with qt_coligadas (ρ = 1) | Rejected |
qt_coligados_agropecuaria has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_alto has constant value "0.0" | Rejected |
qt_coligados_atividade_baixo has constant value "0.0" | Rejected |
qt_coligados_atividade_inativo has constant value "0.0" | Rejected |
qt_coligados_atividade_medio has constant value "0.0" | Rejected |
qt_coligados_atividade_mt_baixo has constant value "0.0" | Rejected |
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99975) | Rejected |
qt_coligados_baixada is highly correlated with max_funcionarios_coligados_gp (ρ = 0.97185) | Rejected |
qt_coligados_ccivil has 189 (71.3%) missing values | Missing |
qt_coligados_centro has 68 (25.7%) zeros | Zeros |
qt_coligados_centro has 189 (71.3%) missing values | Missing |
qt_coligados_comercio has 46 (17.4%) zeros | Zeros |
qt_coligados_comercio has 189 (71.3%) missing values | Missing |
qt_coligados_epp has constant value "0.0" | Rejected |
qt_coligados_exterior has constant value "0.0" | Rejected |
qt_coligados_inapta is highly correlated with max_funcionarios_coligados_gp (ρ = 0.97185) | Rejected |
qt_coligados_industria has 63 (23.8%) zeros | Zeros |
qt_coligados_industria has 189 (71.3%) missing values | Missing |
qt_coligados_ltda has 69 (26.0%) zeros | Zeros |
qt_coligados_ltda has 189 (71.3%) missing values | Missing |
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9997) | Rejected |
qt_coligados_me has constant value "0.0" | Rejected |
qt_coligados_mei has 189 (71.3%) missing values | Missing |
qt_coligados_nordeste has 31 (11.7%) zeros | Zeros |
qt_coligados_nordeste has 189 (71.3%) missing values | Missing |
qt_coligados_norte has 39 (14.7%) zeros | Zeros |
qt_coligados_norte has 189 (71.3%) missing values | Missing |
qt_coligados_nula has constant value "0.0" | Rejected |
qt_coligados_sa has 64 (24.2%) zeros | Zeros |
qt_coligados_sa has 189 (71.3%) missing values | Missing |
qt_coligados_serviço is highly correlated with qt_coligados_matriz (ρ = 0.92884) | Rejected |
qt_coligados_sudeste has 65 (24.5%) zeros | Zeros |
qt_coligados_sudeste has 189 (71.3%) missing values | Missing |
qt_coligados_sul is highly correlated with qt_coligados_baixada (ρ = 0.96129) | Rejected |
qt_coligados_suspensa has constant value "0.0" | Rejected |
qt_desligados is highly correlated with qt_admitidos (ρ = 0.90561) | Rejected |
qt_desligados_12meses has 159 (60.0%) zeros | Zeros |
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) | Rejected |
qt_filiais has 155 (58.5%) zeros | Zeros |
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.99487) | Rejected |
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.96889) | Rejected |
qt_funcionarios_coligados has 5 (1.9%) zeros | Zeros |
qt_funcionarios_coligados has 202 (76.2%) missing values | Missing |
qt_funcionarios_coligados_gp is highly correlated with qt_coligados_inapta (ρ = 0.92314) | Rejected |
qt_funcionarios_grupo is highly correlated with qt_funcionarios_24meses (ρ = 0.9503) | Rejected |
qt_ramos_coligados is highly correlated with qt_coligados_matriz (ρ = 0.93462) | Rejected |
qt_regioes_coligados has 189 (71.3%) missing values | Missing |
qt_socios is highly correlated with qt_coligados_mei (ρ = 0.98995) | Rejected |
qt_socios_coligados has 189 (71.3%) missing values | Missing |
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.99365) | Rejected |
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.99163) | Rejected |
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.99546) | Rejected |
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.99609) | Rejected |
qt_socios_pj has 83 (31.3%) zeros | Zeros |
qt_socios_pj has 167 (63.0%) missing values | Missing |
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) | Rejected |
qt_socios_pj_baixados has constant value "0.0" | Rejected |
qt_socios_pj_inaptos has constant value "0.0" | Rejected |
qt_socios_pj_nulos has constant value "0.0" | Rejected |
qt_socios_pj_suspensos has constant value "0.0" | Rejected |
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.99836) | Rejected |
qt_socios_st_suspensa has constant value "nan" | Rejected |
qt_ufs_coligados is highly correlated with qt_regioes_coligados (ρ = 0.90264) | Rejected |
setor has constant value "SERVIÇO" | Rejected |
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.90166) | Rejected |
total is highly correlated with qt_funcionarios_grupo (ρ = 0.97431) | Rejected |
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.93546) | Rejected |
tx_crescimento_12meses has 161 (60.8%) zeros | Zeros |
tx_crescimento_24meses is highly correlated with tx_crescimento_12meses (ρ = 0.99596) | Rejected |
tx_rotatividade has 160 (60.4%) zeros | Zeros |
vl_faturamento_estimado_grupo_aux is highly correlated with vl_faturamento_estimado_aux (ρ = 0.9811) | Rejected |
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.96112) | Rejected |
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.94289) | Rejected |
vl_frota is highly correlated with qt_socios_pep (ρ = 0.91388) | Rejected |
vl_idade_maxima_socios_pj has 250 (94.3%) missing values | Missing |
vl_idade_media_socios_pj has 250 (94.3%) missing values | Missing |
vl_idade_minima_socios_pj has 250 (94.3%) missing values | Missing |
vl_potenc_cons_oleo_gas has 243 (91.7%) missing values | Missing |
vl_total_tancagem has 255 (96.2%) missing values | Missing |
vl_total_tancagem_grupo is highly correlated with vl_idade_minima_socios_pj (ρ = 0.94442) | Rejected |
vl_total_veiculos_antt has constant value "nan" | Rejected |
vl_total_veiculos_antt_grupo has constant value "nan" | Rejected |
vl_total_veiculos_leves is highly correlated with qt_socios_pep (ρ = 0.93282) | Rejected |
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.99727) | Rejected |
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9929) | Rejected |
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_pesados (ρ = 0.99781) | Rejected |
coligada_mais_antiga_ativa
Numeric
| Distinct count | 77 |
|---|---|
| Unique (%) | 29.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 289.75 |
|---|---|
| Minimum | 2.3 |
| Maximum | 642.67 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.3 |
|---|---|
| 5-th percentile | 24.475 |
| Q1 | 116.31 |
| Median | 272.78 |
| Q3 | 414.34 |
| 95-th percentile | 634.22 |
| Maximum | 642.67 |
| Range | 640.37 |
| Interquartile range | 298.03 |
Descriptive statistics
| Standard deviation | 193.49 |
|---|---|
| Coef of variation | 0.66779 |
| Kurtosis | -1.0216 |
| Mean | 289.75 |
| MAD | 162.51 |
| Skewness | 0.31894 |
| Sum | 22021 |
| Variance | 37440 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 276.63 | 1 | 0.4% | |
| 25.567 | 1 | 0.4% | |
| 42.367 | 1 | 0.4% | |
| 273.17 | 1 | 0.4% | |
| 74.767 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 404.8 | 1 | 0.4% | |
| 178.37 | 1 | 0.4% | |
| 158.6 | 1 | 0.4% | |
| 108.47 | 1 | 0.4% | |
| Other values (66) | 66 | 24.9% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.3 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 19.1 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 25.567 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 642.67 | 1 | 0.4% | |
| 635.47 | 1 | 0.4% | |
| 635.23 | 1 | 0.4% | |
| 634.27 | 1 | 0.4% | |
| 634.2 | 1 | 0.4% |
coligada_mais_antiga_baixada
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
coligada_mais_nova_ativa
Numeric
| Distinct count | 74 |
|---|---|
| Unique (%) | 27.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 92.769 |
|---|---|
| Minimum | 2.0333 |
| Maximum | 498.97 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.0333 |
|---|---|
| 5-th percentile | 3.65 |
| Q1 | 16.658 |
| Median | 39.417 |
| Q3 | 122.04 |
| 95-th percentile | 334.4 |
| Maximum | 498.97 |
| Range | 496.93 |
| Interquartile range | 105.38 |
Descriptive statistics
| Standard deviation | 110.79 |
|---|---|
| Coef of variation | 1.1942 |
| Kurtosis | 2.4526 |
| Mean | 92.769 |
| MAD | 84.736 |
| Skewness | 1.6771 |
| Sum | 7050.5 |
| Variance | 12274 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 19.1 | 2 | 0.8% | |
| 21.2 | 2 | 0.8% | |
| 96.967 | 2 | 0.8% | |
| 161.37 | 1 | 0.4% | |
| 276.63 | 1 | 0.4% | |
| 16.533 | 1 | 0.4% | |
| 8.0333 | 1 | 0.4% | |
| 14.333 | 1 | 0.4% | |
| 26.3 | 1 | 0.4% | |
| 35.567 | 1 | 0.4% | |
| Other values (63) | 63 | 23.8% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.0333 | 1 | 0.4% | |
| 2.3 | 1 | 0.4% | |
| 2.4 | 1 | 0.4% | |
| 3.2 | 1 | 0.4% | |
| 3.8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 498.97 | 1 | 0.4% | |
| 408.47 | 1 | 0.4% | |
| 377.9 | 1 | 0.4% | |
| 355.8 | 1 | 0.4% | |
| 327.27 | 1 | 0.4% |
coligada_mais_nova_baixada
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
de_faixa_faturamento_estimado
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
|---|---|
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 17 |
| Value | Count | Frequency (%) | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 138 | 52.1% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 61 | 23.0% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 49 | 18.5% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 9 | 3.4% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 6 | 2.3% | |
| ACIMA DE 1 BILHAO DE REAIS | 2 | 0.8% |
| Max length | 40 |
|---|---|
| Mean length | 38.913 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_faixa_faturamento_estimado_grupo
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
|---|---|
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 17 |
| Value | Count | Frequency (%) | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 135 | 50.9% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 59 | 22.3% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 54 | 20.4% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 7 | 2.6% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 7 | 2.6% | |
| ACIMA DE 1 BILHAO DE REAIS | 3 | 1.1% |
| Max length | 40 |
|---|---|
| Mean length | 38.887 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_indicador_telefone
Constant
This variable is constant and should be ignored for analysis
| Constant value | BOA |
|---|
de_natureza_juridica
Categorical
| Distinct count | 25 |
|---|---|
| Unique (%) | 9.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MUNICIPIO | |
|---|---|
| SOCIEDADE EMPRESARIA LIMITADA | |
| ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | 20 |
| Other values (22) |
| Value | Count | Frequency (%) | |
| MUNICIPIO | 108 | 40.8% | |
| SOCIEDADE EMPRESARIA LIMITADA | 62 | 23.4% | |
| ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | 20 | 7.5% | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 13 | 4.9% | |
| ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL | 9 | 3.4% | |
| ASSOCIACAO PRIVADA | 8 | 3.0% | |
| AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL | 6 | 2.3% | |
| SERVICO SOCIAL AUTONOMO | 5 | 1.9% | |
| AUTARQUIA FEDERAL | 4 | 1.5% | |
| COOPERATIVA | 4 | 1.5% | |
| Other values (15) | 26 | 9.8% |
| Max length | 70 |
|---|---|
| Mean length | 25.585 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_nivel_atividade
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ALTA | |
|---|---|
| MEDIA | 26 |
| BAIXA | 3 |
| Value | Count | Frequency (%) | |
| ALTA | 236 | 89.1% | |
| MEDIA | 26 | 9.8% | |
| BAIXA | 3 | 1.1% |
| Max length | 5 |
|---|---|
| Mean length | 4.1094 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
de_ramo
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| SERVICOS ADMINISTRATIVOS | |
| SERVICOS DE EDUCACAO | 22 |
| Other values (13) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| SERVICOS ADMINISTRATIVOS | 35 | 13.2% | |
| SERVICOS DE EDUCACAO | 22 | 8.3% | |
| TRANSPORTE, ARMAZENAGEM E CORREIO | 14 | 5.3% | |
| SERVICOS DE SAUDE | 13 | 4.9% | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 5 | 1.9% | |
| SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | 5 | 1.9% | |
| SERVICOS DE SANEAMENTO BASICO | 5 | 1.9% | |
| SERVICOS DIVERSOS | 4 | 1.5% | |
| SEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDE | 3 | 1.1% | |
| Other values (6) | 9 | 3.4% |
| Max length | 49 |
|---|---|
| Mean length | 38.547 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_saude_rescencia
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ACIMA DE 1 ANO | |
|---|---|
| SEM INFORMACAO | 1 |
| ATE 1 ANO | 1 |
| Value | Count | Frequency (%) | |
| ACIMA DE 1 ANO | 263 | 99.2% | |
| SEM INFORMACAO | 1 | 0.4% | |
| ATE 1 ANO | 1 | 0.4% |
| Max length | 14 |
|---|---|
| Mean length | 13.981 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_saude_tributaria
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| VERDE | |
|---|---|
| AZUL | |
| LARANJA | 20 |
| Other values (2) | 3 |
| Value | Count | Frequency (%) | |
| VERDE | 159 | 60.0% | |
| AZUL | 83 | 31.3% | |
| LARANJA | 20 | 7.5% | |
| VERMELHO | 2 | 0.8% | |
| CINZA | 1 | 0.4% |
| Max length | 8 |
|---|---|
| Mean length | 4.8604 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
dt_situacao
Categorical
| Distinct count | 129 |
|---|---|
| Unique (%) | 48.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2005-11-03 | |
|---|---|
| 1998-07-28 | 13 |
| 2005-09-24 | 10 |
| Other values (126) |
| Value | Count | Frequency (%) | |
| 2005-11-03 | 85 | 32.1% | |
| 1998-07-28 | 13 | 4.9% | |
| 2005-09-24 | 10 | 3.8% | |
| 2005-10-14 | 4 | 1.5% | |
| 2005-08-27 | 4 | 1.5% | |
| 2005-10-28 | 4 | 1.5% | |
| 1999-02-27 | 4 | 1.5% | |
| 2005-10-22 | 3 | 1.1% | |
| 2005-08-06 | 3 | 1.1% | |
| 2005-10-07 | 3 | 1.1% | |
| Other values (119) | 132 | 49.8% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
empsetorcensitariofaixarendapopulacao
Numeric
| Distinct count | 208 |
|---|---|
| Unique (%) | 78.5% |
| Missing (%) | 18.1% |
| Missing (n) | 48 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1587.1 |
|---|---|
| Minimum | 297.41 |
| Maximum | 6347.9 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 297.41 |
|---|---|
| 5-th percentile | 405.49 |
| Q1 | 708.95 |
| Median | 1072.3 |
| Q3 | 2179.9 |
| 95-th percentile | 4133.9 |
| Maximum | 6347.9 |
| Range | 6050.4 |
| Interquartile range | 1471 |
Descriptive statistics
| Standard deviation | 1235.8 |
|---|---|
| Coef of variation | 0.77862 |
| Kurtosis | 2.3859 |
| Mean | 1587.1 |
| MAD | 949.7 |
| Skewness | 1.5881 |
| Sum | 3.444e+05 |
| Variance | 1.5271e+06 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1005.1 | 3 | 1.1% | |
| 1068.1 | 2 | 0.8% | |
| 2317.1 | 2 | 0.8% | |
| 1881.3 | 2 | 0.8% | |
| 2179.9 | 2 | 0.8% | |
| 1213.5 | 2 | 0.8% | |
| 1375.7 | 2 | 0.8% | |
| 2799.8 | 2 | 0.8% | |
| 1530.2 | 2 | 0.8% | |
| 960.76 | 1 | 0.4% | |
| Other values (197) | 197 | 74.3% | |
| (Missing) | 48 | 18.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 297.41 | 1 | 0.4% | |
| 339.08 | 1 | 0.4% | |
| 353.66 | 1 | 0.4% | |
| 365.15 | 1 | 0.4% | |
| 365.3 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6347.9 | 1 | 0.4% | |
| 5985.5 | 1 | 0.4% | |
| 5985.4 | 1 | 0.4% | |
| 5463.1 | 1 | 0.4% | |
| 5261.2 | 1 | 0.4% |
faturamento_est_coligados
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 23.4% |
| Missing (%) | 72.1% |
| Missing (n) | 191 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.8928e+08 |
|---|---|
| Minimum | 1.2364e+05 |
| Maximum | 7.5599e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.2364e+05 |
|---|---|
| 5-th percentile | 2.1e+05 |
| Q1 | 8.0728e+05 |
| Median | 5.1921e+06 |
| Q3 | 5.5464e+07 |
| 95-th percentile | 7.1005e+08 |
| Maximum | 7.5599e+09 |
| Range | 7.5598e+09 |
| Interquartile range | 5.4657e+07 |
Descriptive statistics
| Standard deviation | 1.1358e+09 |
|---|---|
| Coef of variation | 3.9263 |
| Kurtosis | 28.391 |
| Mean | 2.8928e+08 |
| MAD | 4.5845e+08 |
| Skewness | 5.228 |
| Sum | 2.1407e+10 |
| Variance | 1.2901e+18 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 10 | 3.8% | |
| 4.2e+05 | 3 | 1.1% | |
| 9.3e+05 | 2 | 0.8% | |
| 4.9455e+05 | 2 | 0.8% | |
| 5.223e+09 | 1 | 0.4% | |
| 8.4164e+07 | 1 | 0.4% | |
| 3.7272e+09 | 1 | 0.4% | |
| 1.1282e+07 | 1 | 0.4% | |
| 9.2894e+08 | 1 | 0.4% | |
| 3.4491e+06 | 1 | 0.4% | |
| Other values (51) | 51 | 19.2% | |
| (Missing) | 191 | 72.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.2364e+05 | 1 | 0.4% | |
| 2.1e+05 | 10 | 3.8% | |
| 2.4728e+05 | 1 | 0.4% | |
| 2.8849e+05 | 1 | 0.4% | |
| 4.2e+05 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7.5599e+09 | 1 | 0.4% | |
| 5.223e+09 | 1 | 0.4% | |
| 3.7272e+09 | 1 | 0.4% | |
| 9.2894e+08 | 1 | 0.4% | |
| 5.9219e+08 | 1 | 0.4% |
faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.97256 |
|---|
fl_antt
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 12 |
| Value | Count | Frequency (%) | |
| False | 253 | 95.5% | |
| True | 12 | 4.5% |
fl_email
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 147 | 55.5% | |
| True | 118 | 44.5% |
fl_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_ltda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 264 | 99.6% | |
| True | 1 | 0.4% |
fl_matriz
Constant
This variable is constant and should be ignored for analysis
| Constant value | True |
|---|
fl_me
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_mei
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_optante_simei
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_optante_simples
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.8% |
| Missing (n) | 2 |
| False | |
|---|---|
| True | 11 |
| (Missing) | 2 |
| Value | Count | Frequency (%) | |
| False | 252 | 95.1% | |
| True | 11 | 4.2% | |
| (Missing) | 2 | 0.8% |
fl_passivel_iss
Constant
This variable is constant and should be ignored for analysis
| Constant value | True |
|---|
fl_rm
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| NAO | |
|---|---|
| SIM |
| Value | Count | Frequency (%) | |
| NAO | 145 | 54.7% | |
| SIM | 120 | 45.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
fl_sa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 5 |
| Value | Count | Frequency (%) | |
| False | 260 | 98.1% | |
| True | 5 | 1.9% |
fl_simples_irregular
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 264 | 99.6% | |
| True | 1 | 0.4% |
fl_spa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 10 |
| Value | Count | Frequency (%) | |
| False | 255 | 96.2% | |
| True | 10 | 3.8% |
fl_st_especial
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_telefone
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 133 | 50.2% | |
| True | 132 | 49.8% |
fl_veiculo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False | 44 |
| Value | Count | Frequency (%) | |
| True | 221 | 83.4% | |
| False | 44 | 16.6% |
grau_instrucao_macro_analfabeto
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 5.7% |
| Missing (%) | 75.8% |
| Missing (n) | 201 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.2188 |
|---|---|
| Minimum | 1 |
| Maximum | 66 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4.25 |
| 95-th percentile | 24 |
| Maximum | 66 |
| Range | 65 |
| Interquartile range | 3.25 |
Descriptive statistics
| Standard deviation | 12.356 |
|---|---|
| Coef of variation | 1.987 |
| Kurtosis | 15.394 |
| Mean | 6.2188 |
| MAD | 6.6924 |
| Skewness | 3.8057 |
| Sum | 398 |
| Variance | 152.68 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 8 | 3.0% | |
| 24 | 3 | 1.1% | |
| 4 | 3 | 1.1% | |
| 9 | 2 | 0.8% | |
| 8 | 2 | 0.8% | |
| 6 | 2 | 0.8% | |
| 7 | 2 | 0.8% | |
| 64 | 1 | 0.4% | |
| Other values (4) | 4 | 1.5% | |
| (Missing) | 201 | 75.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 8 | 3.0% | |
| 4 | 3 | 1.1% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66 | 1 | 0.4% | |
| 64 | 1 | 0.4% | |
| 33 | 1 | 0.4% | |
| 24 | 3 | 1.1% | |
| 12 | 1 | 0.4% |
grau_instrucao_macro_desconhecido
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
grau_instrucao_macro_escolaridade_fundamental
Numeric
| Distinct count | 130 |
|---|---|
| Unique (%) | 49.1% |
| Missing (%) | 4.5% |
| Missing (n) | 12 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 76.553 |
|---|---|
| Minimum | 1 |
| Maximum | 668 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.6 |
| Q1 | 15 |
| Median | 45 |
| Q3 | 96 |
| 95-th percentile | 253 |
| Maximum | 668 |
| Range | 667 |
| Interquartile range | 81 |
Descriptive statistics
| Standard deviation | 105.81 |
|---|---|
| Coef of variation | 1.3822 |
| Kurtosis | 11.184 |
| Mean | 76.553 |
| MAD | 66.396 |
| Skewness | 3.0869 |
| Sum | 19368 |
| Variance | 11196 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 13 | 4.9% | |
| 18 | 7 | 2.6% | |
| 19 | 6 | 2.3% | |
| 4 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 9 | 5 | 1.9% | |
| 17 | 5 | 1.9% | |
| 15 | 5 | 1.9% | |
| 54 | 5 | 1.9% | |
| 12 | 5 | 1.9% | |
| Other values (119) | 190 | 71.7% | |
| (Missing) | 12 | 4.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 13 | 4.9% | |
| 2 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 6 | 2.3% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 668 | 1 | 0.4% | |
| 595 | 1 | 0.4% | |
| 576 | 1 | 0.4% | |
| 559 | 1 | 0.4% | |
| 499 | 1 | 0.4% |
grau_instrucao_macro_escolaridade_media
Numeric
| Distinct count | 196 |
|---|---|
| Unique (%) | 74.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 221.03 |
|---|---|
| Minimum | 4 |
| Maximum | 2447 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 73 |
| Median | 140 |
| Q3 | 255 |
| 95-th percentile | 638.6 |
| Maximum | 2447 |
| Range | 2443 |
| Interquartile range | 182 |
Descriptive statistics
| Standard deviation | 273.2 |
|---|---|
| Coef of variation | 1.2361 |
| Kurtosis | 22.399 |
| Mean | 221.03 |
| MAD | 162.84 |
| Skewness | 3.9717 |
| Sum | 58572 |
| Variance | 74639 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 134 | 4 | 1.5% | |
| 145 | 4 | 1.5% | |
| 49 | 4 | 1.5% | |
| 35 | 3 | 1.1% | |
| 122 | 3 | 1.1% | |
| 23 | 3 | 1.1% | |
| 117 | 3 | 1.1% | |
| 252 | 3 | 1.1% | |
| 40 | 3 | 1.1% | |
| 107 | 3 | 1.1% | |
| Other values (186) | 232 | 87.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 11 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2447 | 1 | 0.4% | |
| 1662 | 1 | 0.4% | |
| 1581 | 1 | 0.4% | |
| 1193 | 2 | 0.8% | |
| 1164 | 1 | 0.4% |
grau_instrucao_macro_escolaridade_superior
Numeric
| Distinct count | 179 |
|---|---|
| Unique (%) | 67.5% |
| Missing (%) | 1.1% |
| Missing (n) | 3 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 174.04 |
|---|---|
| Minimum | 1 |
| Maximum | 2471 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 40.25 |
| Median | 90 |
| Q3 | 192.75 |
| 95-th percentile | 567.75 |
| Maximum | 2471 |
| Range | 2470 |
| Interquartile range | 152.5 |
Descriptive statistics
| Standard deviation | 272.83 |
|---|---|
| Coef of variation | 1.5676 |
| Kurtosis | 26.496 |
| Mean | 174.04 |
| MAD | 155.01 |
| Skewness | 4.4077 |
| Sum | 45599 |
| Variance | 74437 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 3 | 7 | 2.6% | |
| 2 | 5 | 1.9% | |
| 56 | 4 | 1.5% | |
| 8 | 4 | 1.5% | |
| 7 | 4 | 1.5% | |
| 72 | 4 | 1.5% | |
| 63 | 4 | 1.5% | |
| 44 | 3 | 1.1% | |
| 13 | 3 | 1.1% | |
| 37 | 3 | 1.1% | |
| Other values (168) | 221 | 83.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 3 | 1.1% | |
| 2 | 5 | 1.9% | |
| 3 | 7 | 2.6% | |
| 4 | 2 | 0.8% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2471 | 1 | 0.4% | |
| 1820 | 1 | 0.4% | |
| 1349 | 1 | 0.4% | |
| 1292 | 1 | 0.4% | |
| 1168 | 1 | 0.4% |
id
Categorical, Unique
| First 5 values |
|---|
| 001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 |
| 03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058 |
| 04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e |
| 04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673 |
| Last 5 values |
|---|
| fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b |
| fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f |
| feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 |
| ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38 |
First 5 values
| Value | Count | Frequency (%) | |
| 001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c | 1 | 0.4% | |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 | 1 | 0.4% | |
| 03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058 | 1 | 0.4% | |
| 04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e | 1 | 0.4% | |
| 04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673 | 1 | 0.4% |
Last 5 values
| Value | Count | Frequency (%) | |
| ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38 | 1 | 0.4% | |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 | 1 | 0.4% | |
| feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae | 1 | 0.4% | |
| fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f | 1 | 0.4% | |
| fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b | 1 | 0.4% |
idade_acima_de_58
Numeric
| Distinct count | 105 |
|---|---|
| Unique (%) | 39.6% |
| Missing (%) | 3.0% |
| Missing (n) | 8 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.911 |
|---|---|
| Minimum | 1 |
| Maximum | 1844 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 10 |
| Median | 27 |
| Q3 | 57 |
| 95-th percentile | 182.2 |
| Maximum | 1844 |
| Range | 1843 |
| Interquartile range | 47 |
Descriptive statistics
| Standard deviation | 131.14 |
|---|---|
| Coef of variation | 2.4326 |
| Kurtosis | 138.73 |
| Mean | 53.911 |
| MAD | 50.679 |
| Skewness | 10.651 |
| Sum | 13855 |
| Variance | 17199 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2 | 9 | 3.4% | |
| 5 | 9 | 3.4% | |
| 17 | 8 | 3.0% | |
| 3 | 8 | 3.0% | |
| 6 | 8 | 3.0% | |
| 11 | 8 | 3.0% | |
| 12 | 8 | 3.0% | |
| 1 | 7 | 2.6% | |
| 4 | 6 | 2.3% | |
| 8 | 6 | 2.3% | |
| Other values (94) | 180 | 67.9% | |
| (Missing) | 8 | 3.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7 | 2.6% | |
| 2 | 9 | 3.4% | |
| 3 | 8 | 3.0% | |
| 4 | 6 | 2.3% | |
| 5 | 9 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1844 | 1 | 0.4% | |
| 727 | 1 | 0.4% | |
| 307 | 1 | 0.4% | |
| 254 | 1 | 0.4% | |
| 235 | 1 | 0.4% |
idade_ate_18
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | 4.9% |
| Missing (%) | 78.5% |
| Missing (n) | 208 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.4035 |
|---|---|
| Minimum | 1 |
| Maximum | 56 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 5 |
| 95-th percentile | 10 |
| Maximum | 56 |
| Range | 55 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 7.5967 |
|---|---|
| Coef of variation | 1.7251 |
| Kurtosis | 39.315 |
| Mean | 4.4035 |
| MAD | 3.5279 |
| Skewness | 5.8714 |
| Sum | 251 |
| Variance | 57.709 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 16 | 6.0% | |
| 2 | 13 | 4.9% | |
| 3 | 10 | 3.8% | |
| 6 | 5 | 1.9% | |
| 7 | 3 | 1.1% | |
| 4 | 2 | 0.8% | |
| 10 | 2 | 0.8% | |
| 5 | 2 | 0.8% | |
| 8 | 1 | 0.4% | |
| 56 | 1 | 0.4% | |
| Other values (2) | 2 | 0.8% | |
| (Missing) | 208 | 78.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 16 | 6.0% | |
| 2 | 13 | 4.9% | |
| 3 | 10 | 3.8% | |
| 4 | 2 | 0.8% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 56 | 1 | 0.4% | |
| 17 | 1 | 0.4% | |
| 10 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
idade_de_19_a_23
Numeric
| Distinct count | 43 |
|---|---|
| Unique (%) | 16.2% |
| Missing (%) | 28.7% |
| Missing (n) | 76 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15.143 |
|---|---|
| Minimum | 1 |
| Maximum | 643 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 6 |
| Q3 | 16 |
| 95-th percentile | 37.8 |
| Maximum | 643 |
| Range | 642 |
| Interquartile range | 13 |
Descriptive statistics
| Standard deviation | 48.702 |
|---|---|
| Coef of variation | 3.2162 |
| Kurtosis | 148.95 |
| Mean | 15.143 |
| MAD | 14.887 |
| Skewness | 11.647 |
| Sum | 2862 |
| Variance | 2371.9 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 19 | 7.2% | |
| 3 | 15 | 5.7% | |
| 4 | 13 | 4.9% | |
| 6 | 12 | 4.5% | |
| 5 | 12 | 4.5% | |
| 7 | 10 | 3.8% | |
| 10 | 8 | 3.0% | |
| 18 | 6 | 2.3% | |
| 19 | 5 | 1.9% | |
| Other values (32) | 62 | 23.4% | |
| (Missing) | 76 | 28.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 19 | 7.2% | |
| 3 | 15 | 5.7% | |
| 4 | 13 | 4.9% | |
| 5 | 12 | 4.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 643 | 1 | 0.4% | |
| 139 | 1 | 0.4% | |
| 102 | 1 | 0.4% | |
| 65 | 1 | 0.4% | |
| 57 | 1 | 0.4% |
idade_de_24_a_28
Highly correlated
This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis
| Correlation | 0.93912 |
|---|
idade_de_29_a_33
Numeric
| Distinct count | 117 |
|---|---|
| Unique (%) | 44.2% |
| Missing (%) | 0.4% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 61.936 |
|---|---|
| Minimum | 2 |
| Maximum | 749 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 23.75 |
| Median | 40 |
| Q3 | 70.25 |
| 95-th percentile | 171.95 |
| Maximum | 749 |
| Range | 747 |
| Interquartile range | 46.5 |
Descriptive statistics
| Standard deviation | 81.473 |
|---|---|
| Coef of variation | 1.3154 |
| Kurtosis | 29.987 |
| Mean | 61.936 |
| MAD | 44.977 |
| Skewness | 4.7249 |
| Sum | 16351 |
| Variance | 6637.8 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32 | 7 | 2.6% | |
| 31 | 7 | 2.6% | |
| 11 | 7 | 2.6% | |
| 40 | 6 | 2.3% | |
| 22 | 6 | 2.3% | |
| 10 | 6 | 2.3% | |
| 27 | 6 | 2.3% | |
| 29 | 5 | 1.9% | |
| 25 | 5 | 1.9% | |
| 45 | 5 | 1.9% | |
| Other values (106) | 204 | 77.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 2 | 0.8% | |
| 3 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 749 | 1 | 0.4% | |
| 603 | 1 | 0.4% | |
| 517 | 1 | 0.4% | |
| 357 | 1 | 0.4% | |
| 325 | 1 | 0.4% |
idade_de_34_a_38
Numeric
| Distinct count | 123 |
|---|---|
| Unique (%) | 46.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 77.075 |
|---|---|
| Minimum | 1 |
| Maximum | 682 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 28 |
| Median | 45 |
| Q3 | 102 |
| 95-th percentile | 246 |
| Maximum | 682 |
| Range | 681 |
| Interquartile range | 74 |
Descriptive statistics
| Standard deviation | 85.411 |
|---|---|
| Coef of variation | 1.1081 |
| Kurtosis | 14.194 |
| Mean | 77.075 |
| MAD | 55.996 |
| Skewness | 3.181 |
| Sum | 20425 |
| Variance | 7295 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 28 | 8 | 3.0% | |
| 21 | 7 | 2.6% | |
| 27 | 6 | 2.3% | |
| 41 | 6 | 2.3% | |
| 33 | 6 | 2.3% | |
| 42 | 6 | 2.3% | |
| 34 | 6 | 2.3% | |
| 37 | 5 | 1.9% | |
| 22 | 5 | 1.9% | |
| 23 | 5 | 1.9% | |
| Other values (113) | 205 | 77.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% | |
| 9 | 2 | 0.8% | |
| 10 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 682 | 1 | 0.4% | |
| 535 | 1 | 0.4% | |
| 444 | 1 | 0.4% | |
| 375 | 1 | 0.4% | |
| 368 | 1 | 0.4% |
idade_de_39_a_43
Highly correlated
This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis
| Correlation | 0.91473 |
|---|
idade_de_44_a_48
Highly correlated
This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis
| Correlation | 0.93769 |
|---|
idade_de_49_a_53
Numeric
| Distinct count | 116 |
|---|---|
| Unique (%) | 43.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.502 |
|---|---|
| Minimum | 1 |
| Maximum | 532 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5.2 |
| Q1 | 19 |
| Median | 37 |
| Q3 | 64 |
| 95-th percentile | 163 |
| Maximum | 532 |
| Range | 531 |
| Interquartile range | 45 |
Descriptive statistics
| Standard deviation | 58.867 |
|---|---|
| Coef of variation | 1.1003 |
| Kurtosis | 18.511 |
| Mean | 53.502 |
| MAD | 37.916 |
| Skewness | 3.3741 |
| Sum | 14178 |
| Variance | 3465.3 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 14 | 9 | 3.4% | |
| 21 | 6 | 2.3% | |
| 22 | 6 | 2.3% | |
| 31 | 6 | 2.3% | |
| 15 | 6 | 2.3% | |
| 30 | 6 | 2.3% | |
| 28 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 16 | 5 | 1.9% | |
| 8 | 5 | 1.9% | |
| Other values (106) | 204 | 77.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.8% | |
| 2 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 4 | 4 | 1.5% | |
| 5 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 532 | 1 | 0.4% | |
| 315 | 1 | 0.4% | |
| 266 | 1 | 0.4% | |
| 248 | 1 | 0.4% | |
| 235 | 1 | 0.4% |
idade_de_54_a_58
Highly correlated
This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis
| Correlation | 0.95005 |
|---|
idade_emp_cat
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| > 20 | |
|---|---|
| 15 a 20 | 33 |
| 5 a 10 | 27 |
| Other values (3) | 29 |
| Value | Count | Frequency (%) | |
| > 20 | 176 | 66.4% | |
| 15 a 20 | 33 | 12.5% | |
| 5 a 10 | 27 | 10.2% | |
| 10 a 15 | 21 | 7.9% | |
| 1 a 5 | 7 | 2.6% | |
| <= 1 | 1 | 0.4% |
| Max length | 7 |
|---|---|
| Mean length | 4.8415 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
idade_empresa_anos
Numeric
| Distinct count | 214 |
|---|---|
| Unique (%) | 80.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 27.763 |
|---|---|
| Minimum | 0.76164 |
| Maximum | 51.808 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.76164 |
|---|---|
| 5-th percentile | 6.0685 |
| Q1 | 17.638 |
| Median | 24.074 |
| Q3 | 43.8 |
| 95-th percentile | 47.158 |
| Maximum | 51.808 |
| Range | 51.047 |
| Interquartile range | 26.162 |
Descriptive statistics
| Standard deviation | 14.12 |
|---|---|
| Coef of variation | 0.50859 |
| Kurtosis | -1.3337 |
| Mean | 27.763 |
| MAD | 12.567 |
| Skewness | 0.020109 |
| Sum | 7357.1 |
| Variance | 199.36 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 43.855 | 11 | 4.2% | |
| 21.836 | 9 | 3.4% | |
| 21.833 | 6 | 2.3% | |
| 43.866 | 6 | 2.3% | |
| 43.877 | 5 | 1.9% | |
| 43.847 | 4 | 1.5% | |
| 43.868 | 4 | 1.5% | |
| 43.8 | 3 | 1.1% | |
| 21.816 | 3 | 1.1% | |
| 21.814 | 3 | 1.1% | |
| Other values (204) | 211 | 79.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.76164 | 1 | 0.4% | |
| 1.0027 | 1 | 0.4% | |
| 2.4986 | 1 | 0.4% | |
| 2.6 | 1 | 0.4% | |
| 2.9589 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51.808 | 1 | 0.4% | |
| 51.499 | 1 | 0.4% | |
| 51.334 | 1 | 0.4% | |
| 50.929 | 1 | 0.4% | |
| 50.66 | 1 | 0.4% |
idade_maxima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis
| Correlation | 0.99076 |
|---|
idade_maxima_socios
Numeric
| Distinct count | 50 |
|---|---|
| Unique (%) | 18.9% |
| Missing (%) | 64.9% |
| Missing (n) | 172 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 54.968 |
|---|---|
| Minimum | 4 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 31.6 |
| Q1 | 45 |
| Median | 54 |
| Q3 | 66 |
| 95-th percentile | 79.4 |
| Maximum | 90 |
| Range | 86 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 15.466 |
|---|---|
| Coef of variation | 0.28137 |
| Kurtosis | 0.2466 |
| Mean | 54.968 |
| MAD | 12.354 |
| Skewness | -0.22492 |
| Sum | 5112 |
| Variance | 239.21 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 54 | 5 | 1.9% | |
| 50 | 4 | 1.5% | |
| 66 | 4 | 1.5% | |
| 49 | 4 | 1.5% | |
| 51 | 3 | 1.1% | |
| 33 | 3 | 1.1% | |
| 65 | 3 | 1.1% | |
| 47 | 3 | 1.1% | |
| 72 | 3 | 1.1% | |
| 55 | 3 | 1.1% | |
| Other values (39) | 58 | 21.9% | |
| (Missing) | 172 | 64.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 27 | 1 | 0.4% | |
| 29 | 1 | 0.4% | |
| 30 | 1 | 0.4% | |
| 31 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 1 | 0.4% | |
| 86 | 1 | 0.4% | |
| 84 | 1 | 0.4% | |
| 82 | 1 | 0.4% | |
| 80 | 1 | 0.4% |
idade_media_coligadas
Numeric
| Distinct count | 77 |
|---|---|
| Unique (%) | 29.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 174.05 |
|---|---|
| Minimum | 2.3 |
| Maximum | 498.97 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.3 |
|---|---|
| 5-th percentile | 24.475 |
| Q1 | 102.83 |
| Median | 156.66 |
| Q3 | 243.95 |
| 95-th percentile | 382.36 |
| Maximum | 498.97 |
| Range | 496.67 |
| Interquartile range | 141.12 |
Descriptive statistics
| Standard deviation | 108.48 |
|---|---|
| Coef of variation | 0.62325 |
| Kurtosis | 0.78332 |
| Mean | 174.05 |
| MAD | 85.839 |
| Skewness | 0.8318 |
| Sum | 13228 |
| Variance | 11768 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 102.87 | 1 | 0.4% | |
| 358.94 | 1 | 0.4% | |
| 495.95 | 1 | 0.4% | |
| 16.8 | 1 | 0.4% | |
| 44.067 | 1 | 0.4% | |
| 276.63 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 194.23 | 1 | 0.4% | |
| 408.47 | 1 | 0.4% | |
| 102.72 | 1 | 0.4% | |
| Other values (66) | 66 | 24.9% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.3 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 16.8 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 25.567 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 498.97 | 1 | 0.4% | |
| 495.95 | 1 | 0.4% | |
| 408.47 | 1 | 0.4% | |
| 389.98 | 1 | 0.4% | |
| 379.82 | 1 | 0.4% |
idade_media_coligadas_ativas
Highly correlated
This variable is highly correlated with idade_media_coligadas and should be ignored for analysis
| Correlation | 0.99283 |
|---|
idade_media_coligadas_baixadas
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
idade_media_socios
Numeric
| Distinct count | 63 |
|---|---|
| Unique (%) | 23.8% |
| Missing (%) | 64.9% |
| Missing (n) | 172 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 49.949 |
|---|---|
| Minimum | 4 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 29.4 |
| Q1 | 41 |
| Median | 50 |
| Q3 | 61 |
| 95-th percentile | 70.3 |
| Maximum | 90 |
| Range | 86 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 13.803 |
|---|---|
| Coef of variation | 0.27634 |
| Kurtosis | 0.51101 |
| Mean | 49.949 |
| MAD | 11.173 |
| Skewness | -0.11851 |
| Sum | 4645.3 |
| Variance | 190.52 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 64 | 3 | 1.1% | |
| 63 | 3 | 1.1% | |
| 55 | 3 | 1.1% | |
| 47 | 3 | 1.1% | |
| 33 | 3 | 1.1% | |
| 50 | 3 | 1.1% | |
| 52 | 3 | 1.1% | |
| 69 | 2 | 0.8% | |
| 46.667 | 2 | 0.8% | |
| 64.5 | 2 | 0.8% | |
| Other values (52) | 66 | 24.9% | |
| (Missing) | 172 | 64.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 27 | 2 | 0.8% | |
| 28 | 1 | 0.4% | |
| 28.5 | 1 | 0.4% | |
| 30 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 1 | 0.4% | |
| 75.667 | 1 | 0.4% | |
| 72 | 1 | 0.4% | |
| 71 | 1 | 0.4% | |
| 70.75 | 1 | 0.4% |
idade_minima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis
| Correlation | 1 |
|---|
idade_minima_socios
Highly correlated
This variable is highly correlated with idade_media_socios and should be ignored for analysis
| Correlation | 0.90301 |
|---|
max_faturamento_est_coligados
Highly correlated
This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.94847 |
|---|
max_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.95153 |
|---|
max_filiais_coligados
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 5.7% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.583 |
|---|---|
| Minimum | 1 |
| Maximum | 666 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| Median | 4 |
| Q3 | 7 |
| 95-th percentile | 178.25 |
| Maximum | 666 |
| Range | 665 |
| Interquartile range | 5.25 |
Descriptive statistics
| Standard deviation | 120.67 |
|---|---|
| Coef of variation | 2.9734 |
| Kurtosis | 21.728 |
| Mean | 40.583 |
| MAD | 61.583 |
| Skewness | 4.445 |
| Sum | 1461 |
| Variance | 14561 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 4 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 2 | 4 | 1.5% | |
| 7 | 3 | 1.1% | |
| 6 | 3 | 1.1% | |
| 5 | 2 | 0.8% | |
| 275 | 1 | 0.4% | |
| 666 | 1 | 0.4% | |
| 146 | 1 | 0.4% | |
| Other values (4) | 4 | 1.5% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 666 | 1 | 0.4% | |
| 275 | 1 | 0.4% | |
| 146 | 1 | 0.4% | |
| 140 | 1 | 0.4% | |
| 76 | 1 | 0.4% |
max_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with max_filiais_coligados and should be ignored for analysis
| Correlation | 0.93125 |
|---|
max_meses_servicos
Numeric
| Distinct count | 228 |
|---|---|
| Unique (%) | 86.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 472.16 |
|---|---|
| Minimum | 6 |
| Maximum | 5099.1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 46.493 |
| Q1 | 251.5 |
| Median | 414.33 |
| Q3 | 521.37 |
| 95-th percentile | 641.31 |
| Maximum | 5099.1 |
| Range | 5093.1 |
| Interquartile range | 269.87 |
Descriptive statistics
| Standard deviation | 729.18 |
|---|---|
| Coef of variation | 1.5443 |
| Kurtosis | 34.677 |
| Mean | 472.16 |
| MAD | 268.11 |
| Skewness | 5.8153 |
| Sum | 1.2512e+05 |
| Variance | 5.317e+05 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 5099.1 | 6 | 2.3% | |
| 265.63 | 5 | 1.9% | |
| 470.67 | 5 | 1.9% | |
| 507.2 | 5 | 1.9% | |
| 265.67 | 4 | 1.5% | |
| 521.37 | 4 | 1.5% | |
| 481.83 | 3 | 1.1% | |
| 495.03 | 3 | 1.1% | |
| 263.7 | 2 | 0.8% | |
| 123.63 | 2 | 0.8% | |
| Other values (218) | 226 | 85.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6 | 1 | 0.4% | |
| 13.067 | 1 | 0.4% | |
| 26.233 | 1 | 0.4% | |
| 29.3 | 1 | 0.4% | |
| 30.333 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.1 | 6 | 2.3% | |
| 804.43 | 1 | 0.4% | |
| 801.37 | 1 | 0.4% | |
| 707.37 | 1 | 0.4% | |
| 679.63 | 1 | 0.4% |
max_meses_servicos_all
Numeric
| Distinct count | 154 |
|---|---|
| Unique (%) | 58.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2134.5 |
|---|---|
| Minimum | 13.067 |
| Maximum | 5099.1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 13.067 |
|---|---|
| 5-th percentile | 53.447 |
| Q1 | 257.33 |
| Median | 490.43 |
| Q3 | 5015 |
| 95-th percentile | 5015 |
| Maximum | 5099.1 |
| Range | 5086 |
| Interquartile range | 4757.6 |
Descriptive statistics
| Standard deviation | 2311.3 |
|---|---|
| Coef of variation | 1.0828 |
| Kurtosis | -1.7977 |
| Mean | 2134.5 |
| MAD | 2245.2 |
| Skewness | 0.44911 |
| Sum | 5.6564e+05 |
| Variance | 5.3422e+06 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 5015 | 91 | 34.3% | |
| 5099.1 | 6 | 2.3% | |
| 5064.7 | 5 | 1.9% | |
| 265.63 | 4 | 1.5% | |
| 265.67 | 4 | 1.5% | |
| 113.53 | 2 | 0.8% | |
| 481.83 | 2 | 0.8% | |
| 373.27 | 2 | 0.8% | |
| 387.43 | 2 | 0.8% | |
| 50.6 | 2 | 0.8% | |
| Other values (144) | 145 | 54.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 13.067 | 1 | 0.4% | |
| 26.233 | 1 | 0.4% | |
| 29.3 | 1 | 0.4% | |
| 29.367 | 1 | 0.4% | |
| 30.4 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.1 | 6 | 2.3% | |
| 5065.7 | 1 | 0.4% | |
| 5064.7 | 5 | 1.9% | |
| 5015 | 91 | 34.3% | |
| 679.63 | 1 | 0.4% |
max_vl_folha_coligados
Numeric
| Distinct count | 56 |
|---|---|
| Unique (%) | 21.1% |
| Missing (%) | 78.1% |
| Missing (n) | 207 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.87e+07 |
|---|---|
| Minimum | 0 |
| Maximum | 2.0771e+08 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.4115e+05 |
| Q1 | 8.191e+05 |
| Median | 7.8716e+06 |
| Q3 | 3.1667e+07 |
| 95-th percentile | 1.6598e+08 |
| Maximum | 2.0771e+08 |
| Range | 2.0771e+08 |
| Interquartile range | 3.0848e+07 |
Descriptive statistics
| Standard deviation | 5.0411e+07 |
|---|---|
| Coef of variation | 1.7565 |
| Kurtosis | 5.4277 |
| Mean | 2.87e+07 |
| MAD | 3.39e+07 |
| Skewness | 2.4373 |
| Sum | 1.6646e+09 |
| Variance | 2.5413e+15 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.4728e+05 | 3 | 1.1% | |
| 3.7092e+05 | 2 | 0.8% | |
| 1.3003e+07 | 1 | 0.4% | |
| 1.2343e+08 | 1 | 0.4% | |
| 7.5131e+07 | 1 | 0.4% | |
| 8.5310e+06 | 1 | 0.4% | |
| 3.3959e+07 | 1 | 0.4% | |
| 4.3953e+07 | 1 | 0.4% | |
| 8.2426e+06 | 1 | 0.4% | |
| 4.2243e+06 | 1 | 0.4% | |
| Other values (45) | 45 | 17.0% | |
| (Missing) | 207 | 78.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.4% | |
| 61819 | 1 | 0.4% | |
| 1.2364e+05 | 1 | 0.4% | |
| 1.4424e+05 | 1 | 0.4% | |
| 1.8546e+05 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.0771e+08 | 1 | 0.4% | |
| 2.0392e+08 | 1 | 0.4% | |
| 1.7157e+08 | 1 | 0.4% | |
| 1.65e+08 | 1 | 0.4% | |
| 1.2343e+08 | 1 | 0.4% |
max_vl_folha_coligados_gp
Numeric
| Distinct count | 58 |
|---|---|
| Unique (%) | 21.9% |
| Missing (%) | 77.7% |
| Missing (n) | 206 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.5771e+07 |
|---|---|
| Minimum | 61819 |
| Maximum | 1.3901e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819 |
|---|---|
| 5-th percentile | 1.8134e+05 |
| Q1 | 1.1127e+06 |
| Median | 8.2426e+06 |
| Q3 | 4.1161e+07 |
| 95-th percentile | 2.8546e+08 |
| Maximum | 1.3901e+09 |
| Range | 1.3901e+09 |
| Interquartile range | 4.0049e+07 |
Descriptive statistics
| Standard deviation | 2.2829e+08 |
|---|---|
| Coef of variation | 3.0129 |
| Kurtosis | 22.01 |
| Mean | 7.5771e+07 |
| MAD | 1.0578e+08 |
| Skewness | 4.5546 |
| Sum | 4.4705e+09 |
| Variance | 5.2115e+16 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.4728e+05 | 3 | 1.1% | |
| 6.8207e+06 | 1 | 0.4% | |
| 1.2343e+08 | 1 | 0.4% | |
| 8.5310e+06 | 1 | 0.4% | |
| 4.3953e+07 | 1 | 0.4% | |
| 8.2426e+06 | 1 | 0.4% | |
| 7.8304e+05 | 1 | 0.4% | |
| 2.8849e+05 | 1 | 0.4% | |
| 1.2362e+08 | 1 | 0.4% | |
| 4.4736e+07 | 1 | 0.4% | |
| Other values (47) | 47 | 17.7% | |
| (Missing) | 206 | 77.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819 | 1 | 0.4% | |
| 1.2364e+05 | 1 | 0.4% | |
| 1.4424e+05 | 1 | 0.4% | |
| 1.8546e+05 | 1 | 0.4% | |
| 2.4728e+05 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.3901e+09 | 1 | 0.4% | |
| 8.9807e+08 | 1 | 0.4% | |
| 6.783e+08 | 1 | 0.4% | |
| 2.4182e+08 | 1 | 0.4% | |
| 1.7742e+08 | 1 | 0.4% |
media_faturamento_est_coligados
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.90753 |
|---|
media_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.94656 |
|---|
media_filiais_coligados
Numeric
| Distinct count | 20 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.004 |
|---|---|
| Minimum | 1 |
| Maximum | 63 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.5 |
| Median | 2.1 |
| Q3 | 4.125 |
| 95-th percentile | 41.125 |
| Maximum | 63 |
| Range | 62 |
| Interquartile range | 2.625 |
Descriptive statistics
| Standard deviation | 14.361 |
|---|---|
| Coef of variation | 1.7942 |
| Kurtosis | 7.1143 |
| Mean | 8.004 |
| MAD | 9.2683 |
| Skewness | 2.7226 |
| Sum | 288.14 |
| Variance | 206.22 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 2 | 8 | 3.0% | |
| 4 | 3 | 1.1% | |
| 2.5556 | 1 | 0.4% | |
| 10 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 2.5 | 1 | 0.4% | |
| 63 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 1.6667 | 1 | 0.4% | |
| Other values (9) | 9 | 3.4% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 1.6667 | 1 | 0.4% | |
| 2 | 8 | 3.0% | |
| 2.2 | 1 | 0.4% | |
| 2.3636 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 63 | 1 | 0.4% | |
| 49 | 1 | 0.4% | |
| 38.5 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 24 | 1 | 0.4% |
media_funcionarios_coligados_gp
Numeric
| Distinct count | 56 |
|---|---|
| Unique (%) | 21.1% |
| Missing (%) | 76.2% |
| Missing (n) | 202 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 243.25 |
|---|---|
| Minimum | 0 |
| Maximum | 4398.6 |
| Zeros (%) | 1.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 7.6667 |
| Median | 45 |
| Q3 | 150 |
| 95-th percentile | 846.66 |
| Maximum | 4398.6 |
| Range | 4398.6 |
| Interquartile range | 142.33 |
Descriptive statistics
| Standard deviation | 652.23 |
|---|---|
| Coef of variation | 2.6814 |
| Kurtosis | 28.057 |
| Mean | 243.25 |
| MAD | 311.8 |
| Skewness | 4.9629 |
| Sum | 15324 |
| Variance | 4.2541e+05 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 4 | 4 | 1.5% | |
| 0 | 4 | 1.5% | |
| 10 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 25 | 1 | 0.4% | |
| 45 | 1 | 0.4% | |
| 119 | 1 | 0.4% | |
| 28.25 | 1 | 0.4% | |
| 77 | 1 | 0.4% | |
| 37 | 1 | 0.4% | |
| Other values (45) | 45 | 17.0% | |
| (Missing) | 202 | 76.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4 | 1.5% | |
| 1 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4398.6 | 1 | 0.4% | |
| 2112 | 1 | 0.4% | |
| 1878.3 | 1 | 0.4% | |
| 851.43 | 1 | 0.4% | |
| 803.68 | 1 | 0.4% |
media_meses_servicos
Numeric
| Distinct count | 265 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 129.43 |
|---|---|
| Minimum | 5.947 |
| Maximum | 353.95 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 5.947 |
|---|---|
| 5-th percentile | 22.162 |
| Q1 | 58.735 |
| Median | 138.39 |
| Q3 | 182.09 |
| 95-th percentile | 234.58 |
| Maximum | 353.95 |
| Range | 348.01 |
| Interquartile range | 123.36 |
Descriptive statistics
| Standard deviation | 73.441 |
|---|---|
| Coef of variation | 0.5674 |
| Kurtosis | -0.64313 |
| Mean | 129.43 |
| MAD | 62.156 |
| Skewness | 0.14637 |
| Sum | 34300 |
| Variance | 5393.6 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 47.866 | 1 | 0.4% | |
| 146.84 | 1 | 0.4% | |
| 30.829 | 1 | 0.4% | |
| 40.411 | 1 | 0.4% | |
| 235.27 | 1 | 0.4% | |
| 48.28 | 1 | 0.4% | |
| 160.5 | 1 | 0.4% | |
| 58.735 | 1 | 0.4% | |
| 202.02 | 1 | 0.4% | |
| 201.51 | 1 | 0.4% | |
| Other values (255) | 255 | 96.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 5.947 | 1 | 0.4% | |
| 10.966 | 1 | 0.4% | |
| 11.984 | 1 | 0.4% | |
| 14.42 | 1 | 0.4% | |
| 15.148 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 353.95 | 1 | 0.4% | |
| 319.02 | 1 | 0.4% | |
| 313.49 | 1 | 0.4% | |
| 310.82 | 1 | 0.4% | |
| 288.75 | 1 | 0.4% |
media_meses_servicos_all
Numeric
| Distinct count | 265 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 120.28 |
|---|---|
| Minimum | 6.1155 |
| Maximum | 576.62 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6.1155 |
|---|---|
| 5-th percentile | 16.111 |
| Q1 | 39.685 |
| Median | 110.73 |
| Q3 | 173.47 |
| 95-th percentile | 260.45 |
| Maximum | 576.62 |
| Range | 570.51 |
| Interquartile range | 133.79 |
Descriptive statistics
| Standard deviation | 92.931 |
|---|---|
| Coef of variation | 0.7726 |
| Kurtosis | 3.981 |
| Mean | 120.28 |
| MAD | 71.725 |
| Skewness | 1.4537 |
| Sum | 31875 |
| Variance | 8636.2 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 295.41 | 1 | 0.4% | |
| 119.62 | 1 | 0.4% | |
| 35.878 | 1 | 0.4% | |
| 192.4 | 1 | 0.4% | |
| 93.25 | 1 | 0.4% | |
| 137.19 | 1 | 0.4% | |
| 30.172 | 1 | 0.4% | |
| 113.89 | 1 | 0.4% | |
| 94.247 | 1 | 0.4% | |
| 152.47 | 1 | 0.4% | |
| Other values (255) | 255 | 96.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6.1155 | 1 | 0.4% | |
| 8.897 | 1 | 0.4% | |
| 8.9103 | 1 | 0.4% | |
| 9.2744 | 1 | 0.4% | |
| 10.881 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 576.62 | 1 | 0.4% | |
| 552.77 | 1 | 0.4% | |
| 519.21 | 1 | 0.4% | |
| 367.72 | 1 | 0.4% | |
| 361.37 | 1 | 0.4% |
media_vl_folha_coligados
Numeric
| Distinct count | 57 |
|---|---|
| Unique (%) | 21.5% |
| Missing (%) | 78.1% |
| Missing (n) | 207 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.1428e+06 |
|---|---|
| Minimum | 0 |
| Maximum | 1.2343e+08 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.4115e+05 |
| Q1 | 4.894e+05 |
| Median | 4.2346e+06 |
| Q3 | 1.0169e+07 |
| 95-th percentile | 2.6651e+07 |
| Maximum | 1.2343e+08 |
| Range | 1.2343e+08 |
| Interquartile range | 9.6799e+06 |
Descriptive statistics
| Standard deviation | 1.773e+07 |
|---|---|
| Coef of variation | 1.9392 |
| Kurtosis | 30.815 |
| Mean | 9.1428e+06 |
| MAD | 9.4667e+06 |
| Skewness | 5.0062 |
| Sum | 5.3028e+08 |
| Variance | 3.1434e+14 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.4728e+05 | 3 | 1.1% | |
| 5.9759e+05 | 1 | 0.4% | |
| 2.1637e+05 | 1 | 0.4% | |
| 4.2449e+06 | 1 | 0.4% | |
| 4.2243e+06 | 1 | 0.4% | |
| 1.3992e+07 | 1 | 0.4% | |
| 2.72e+06 | 1 | 0.4% | |
| 5.4727e+06 | 1 | 0.4% | |
| 61819 | 1 | 0.4% | |
| 3.6696e+07 | 1 | 0.4% | |
| Other values (46) | 46 | 17.4% | |
| (Missing) | 207 | 78.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.4% | |
| 61819 | 1 | 0.4% | |
| 1.2364e+05 | 1 | 0.4% | |
| 1.4424e+05 | 1 | 0.4% | |
| 1.8546e+05 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.2343e+08 | 1 | 0.4% | |
| 3.8369e+07 | 1 | 0.4% | |
| 3.6696e+07 | 1 | 0.4% | |
| 2.4878e+07 | 1 | 0.4% | |
| 2.4383e+07 | 1 | 0.4% |
media_vl_folha_coligados_gp
Numeric
| Distinct count | 58 |
|---|---|
| Unique (%) | 21.9% |
| Missing (%) | 77.7% |
| Missing (n) | 206 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.4371e+07 |
|---|---|
| Minimum | 61819 |
| Maximum | 1.2343e+08 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819 |
|---|---|
| 5-th percentile | 1.8134e+05 |
| Q1 | 7.238e+05 |
| Median | 4.7189e+06 |
| Q3 | 1.1292e+07 |
| 95-th percentile | 6.3809e+07 |
| Maximum | 1.2343e+08 |
| Range | 1.2337e+08 |
| Interquartile range | 1.0569e+07 |
Descriptive statistics
| Standard deviation | 2.5761e+07 |
|---|---|
| Coef of variation | 1.7925 |
| Kurtosis | 8.0327 |
| Mean | 1.4371e+07 |
| MAD | 1.6633e+07 |
| Skewness | 2.788 |
| Sum | 8.4791e+08 |
| Variance | 6.6365e+14 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.4728e+05 | 3 | 1.1% | |
| 2.0716e+07 | 1 | 0.4% | |
| 8.5310e+06 | 1 | 0.4% | |
| 7.8304e+05 | 1 | 0.4% | |
| 1.8127e+07 | 1 | 0.4% | |
| 2.1637e+05 | 1 | 0.4% | |
| 6.1812e+07 | 1 | 0.4% | |
| 2.72e+06 | 1 | 0.4% | |
| 61819 | 1 | 0.4% | |
| 8.7989e+06 | 1 | 0.4% | |
| Other values (47) | 47 | 17.7% | |
| (Missing) | 206 | 77.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819 | 1 | 0.4% | |
| 1.2364e+05 | 1 | 0.4% | |
| 1.4424e+05 | 1 | 0.4% | |
| 1.8546e+05 | 1 | 0.4% | |
| 2.1637e+05 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.2343e+08 | 1 | 0.4% | |
| 1.1024e+08 | 1 | 0.4% | |
| 8.1778e+07 | 1 | 0.4% | |
| 6.1812e+07 | 1 | 0.4% | |
| 5.2856e+07 | 1 | 0.4% |
meses_ultima_contratacaco
Numeric
| Distinct count | 137 |
|---|---|
| Unique (%) | 51.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19.388 |
|---|---|
| Minimum | 1.9667 |
| Maximum | 112.17 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.9667 |
|---|---|
| 5-th percentile | 2.0667 |
| Q1 | 2.9333 |
| Median | 23.2 |
| Q3 | 27.9 |
| 95-th percentile | 42.513 |
| Maximum | 112.17 |
| Range | 110.2 |
| Interquartile range | 24.967 |
Descriptive statistics
| Standard deviation | 16.074 |
|---|---|
| Coef of variation | 0.82905 |
| Kurtosis | 4.6061 |
| Mean | 19.388 |
| MAD | 12.865 |
| Skewness | 1.2956 |
| Sum | 5137.8 |
| Variance | 258.36 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.9333 | 16 | 6.0% | |
| 23.2 | 13 | 4.9% | |
| 24.2 | 10 | 3.8% | |
| 2.0667 | 10 | 3.8% | |
| 2.3 | 7 | 2.6% | |
| 30.333 | 6 | 2.3% | |
| 2.5333 | 6 | 2.3% | |
| 2.2 | 5 | 1.9% | |
| 2.0333 | 5 | 1.9% | |
| 28.3 | 5 | 1.9% | |
| Other values (127) | 182 | 68.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.9667 | 3 | 1.1% | |
| 2 | 1 | 0.4% | |
| 2.0333 | 5 | 1.9% | |
| 2.0667 | 10 | 3.8% | |
| 2.1667 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 112.17 | 1 | 0.4% | |
| 88.167 | 1 | 0.4% | |
| 70.867 | 1 | 0.4% | |
| 68.9 | 1 | 0.4% | |
| 65.833 | 1 | 0.4% |
min_faturamento_est_coligados
Numeric
| Distinct count | 26 |
|---|---|
| Unique (%) | 9.8% |
| Missing (%) | 72.1% |
| Missing (n) | 191 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.9014e+06 |
|---|---|
| Minimum | 50000 |
| Maximum | 3.2507e+07 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 50000 |
|---|---|
| 5-th percentile | 1.2364e+05 |
| Q1 | 2.1e+05 |
| Median | 2.1e+05 |
| Q3 | 4.9455e+05 |
| 95-th percentile | 1.6596e+07 |
| Maximum | 3.2507e+07 |
| Range | 3.2457e+07 |
| Interquartile range | 2.8455e+05 |
Descriptive statistics
| Standard deviation | 5.7207e+06 |
|---|---|
| Coef of variation | 3.0087 |
| Kurtosis | 15.212 |
| Mean | 1.9014e+06 |
| MAD | 2.851e+06 |
| Skewness | 3.8983 |
| Sum | 1.407e+08 |
| Variance | 3.2726e+13 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 39 | 14.7% | |
| 1.2364e+05 | 8 | 3.0% | |
| 4.9455e+05 | 3 | 1.1% | |
| 6.1819e+05 | 2 | 0.8% | |
| 9.3e+05 | 2 | 0.8% | |
| 2.1328e+07 | 1 | 0.4% | |
| 1.1952e+06 | 1 | 0.4% | |
| 3.0085e+06 | 1 | 0.4% | |
| 3.2507e+07 | 1 | 0.4% | |
| 1.6434e+07 | 1 | 0.4% | |
| Other values (15) | 15 | 5.7% | |
| (Missing) | 191 | 72.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 50000 | 1 | 0.4% | |
| 1.2364e+05 | 8 | 3.0% | |
| 1.6485e+05 | 1 | 0.4% | |
| 1.8546e+05 | 1 | 0.4% | |
| 2.0606e+05 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.2507e+07 | 1 | 0.4% | |
| 2.3182e+07 | 1 | 0.4% | |
| 2.1328e+07 | 1 | 0.4% | |
| 1.6897e+07 | 1 | 0.4% | |
| 1.6434e+07 | 1 | 0.4% |
min_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.98448 |
|---|
min_filiais_coligados
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | 3.0% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.9722 |
|---|---|
| Minimum | 1 |
| Maximum | 49 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 5.25 |
| Maximum | 49 |
| Range | 48 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.9839 |
|---|---|
| Coef of variation | 2.6862 |
| Kurtosis | 34.197 |
| Mean | 2.9722 |
| MAD | 2.8997 |
| Skewness | 5.7876 |
| Sum | 107 |
| Variance | 63.742 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 5 | 1.9% | |
| 3 | 3 | 1.1% | |
| 49 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 5 | 1.9% | |
| 3 | 3 | 1.1% | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 49 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 3 | 3 | 1.1% |
min_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with min_filiais_coligados and should be ignored for analysis
| Correlation | 0.91607 |
|---|
min_meses_servicos
Highly correlated
This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis
| Correlation | 0.95675 |
|---|
min_meses_servicos_all
Numeric
| Distinct count | 125 |
|---|---|
| Unique (%) | 47.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.3312 |
|---|---|
| Minimum | -11.7 |
| Maximum | 66.933 |
| Zeros (%) | 7.2% |
Quantile statistics
| Minimum | -11.7 |
|---|---|
| 5-th percentile | -6.1 |
| Q1 | -0.63333 |
| Median | 0 |
| Q3 | 1.6667 |
| 95-th percentile | 10.873 |
| Maximum | 66.933 |
| Range | 78.633 |
| Interquartile range | 2.3 |
Descriptive statistics
| Standard deviation | 7.1 |
|---|---|
| Coef of variation | 5.3335 |
| Kurtosis | 33.658 |
| Mean | 1.3312 |
| MAD | 3.5908 |
| Skewness | 4.5789 |
| Sum | 352.77 |
| Variance | 50.41 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 19 | 7.2% | |
| 1 | 14 | 5.3% | |
| -0.53333 | 9 | 3.4% | |
| -0.033333 | 8 | 3.0% | |
| -0.73333 | 6 | 2.3% | |
| 0.2 | 6 | 2.3% | |
| -0.4 | 5 | 1.9% | |
| 8.1333 | 5 | 1.9% | |
| 2.0333 | 5 | 1.9% | |
| -0.56667 | 4 | 1.5% | |
| Other values (115) | 184 | 69.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -11.7 | 1 | 0.4% | |
| -11.2 | 2 | 0.8% | |
| -11.167 | 1 | 0.4% | |
| -10.167 | 1 | 0.4% | |
| -9.8333 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66.933 | 1 | 0.4% | |
| 44.2 | 1 | 0.4% | |
| 27.7 | 1 | 0.4% | |
| 27.5 | 1 | 0.4% | |
| 26.7 | 1 | 0.4% |
min_vl_folha_coligados
Highly correlated
This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.99898 |
|---|
min_vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis
| Correlation | 0.99917 |
|---|
natureza_juridica_macro
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| OUTROS | |
|---|---|
| ENTIDADES EMPRESARIAIS | |
| ADMINISTRACAO PUBLICA |
| Value | Count | Frequency (%) | |
| OUTROS | 128 | 48.3% | |
| ENTIDADES EMPRESARIAIS | 73 | 27.5% | |
| ADMINISTRACAO PUBLICA | 47 | 17.7% | |
| ENTIDADES SEM FINS LUCRATIVOS | 17 | 6.4% |
| Max length | 29 |
|---|---|
| Mean length | 14.543 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_divisao
Categorical
| Distinct count | 26 |
|---|---|
| Unique (%) | 9.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| EDUCACAO | 22 |
| SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | 18 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| EDUCACAO | 22 | 8.3% | |
| SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | 18 | 6.8% | |
| ATIVIDADES DE ATENCAO A SAUDE HUMANA | 12 | 4.5% | |
| TRANSPORTE TERRESTRE | 12 | 4.5% | |
| SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA | 6 | 2.3% | |
| ALIMENTACAO | 4 | 1.5% | |
| SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS | 4 | 1.5% | |
| SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | 4 | 1.5% | |
| ATIVIDADES DE VIGILANCIA SEGURANCA E INVESTIGACAO | 4 | 1.5% | |
| Other values (16) | 29 | 10.9% |
| Max length | 120 |
|---|---|
| Mean length | 43.509 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_meso_regiao
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 9.1% |
| Missing (n) | 24 |
| NORTE MARANHENSE | |
|---|---|
| CENTRO AMAZONENSE | |
| CENTRO NORTE PIAUIENSE | |
| Other values (16) | |
| (Missing) | 24 |
| Value | Count | Frequency (%) | |
| NORTE MARANHENSE | 41 | 15.5% | |
| CENTRO AMAZONENSE | 39 | 14.7% | |
| CENTRO NORTE PIAUIENSE | 31 | 11.7% | |
| LESTE POTIGUAR | 23 | 8.7% | |
| VALE DO ACRE | 21 | 7.9% | |
| OESTE POTIGUAR | 13 | 4.9% | |
| CENTRO MARANHENSE | 11 | 4.2% | |
| SUDESTE PIAUIENSE | 11 | 4.2% | |
| OESTE MARANHENSE | 10 | 3.8% | |
| AGRESTE POTIGUAR | 8 | 3.0% | |
| Other values (9) | 33 | 12.5% | |
| (Missing) | 24 | 9.1% |
| Max length | 22 |
|---|---|
| Mean length | 15.162 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_micro_regiao
Categorical
| Distinct count | 57 |
|---|---|
| Unique (%) | 21.5% |
| Missing (%) | 9.1% |
| Missing (n) | 24 |
| MANAUS | |
|---|---|
| AGLOMERACAO URBANA DE SAO LUIS | |
| TERESINA | 21 |
| Other values (53) | |
| (Missing) | 24 |
| Value | Count | Frequency (%) | |
| MANAUS | 38 | 14.3% | |
| AGLOMERACAO URBANA DE SAO LUIS | 32 | 12.1% | |
| TERESINA | 21 | 7.9% | |
| RIO BRANCO | 19 | 7.2% | |
| NATAL | 18 | 6.8% | |
| PICOS | 6 | 2.3% | |
| PINDARE | 6 | 2.3% | |
| MEDIO MEARIM | 6 | 2.3% | |
| ALTO MEDIO CANINDE | 5 | 1.9% | |
| CAMPO MAIOR | 5 | 1.9% | |
| Other values (46) | 85 | 32.1% | |
| (Missing) | 24 | 9.1% |
| Max length | 30 |
|---|---|
| Mean length | 12.347 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_segmento
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | 4.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | |
| EDUCACAO | 22 |
| Other values (10) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 35 | 13.2% | |
| EDUCACAO | 22 | 8.3% | |
| TRANSPORTE ARMAZENAGEM E CORREIO | 14 | 5.3% | |
| SAUDE HUMANA E SERVICOS SOCIAIS | 14 | 5.3% | |
| ALOJAMENTO E ALIMENTACAO | 5 | 1.9% | |
| ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 5 | 1.9% | |
| ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS | 5 | 1.9% | |
| AGUA ESGOTO ATIVIDADES DE GESTAO DE RESIDUOS E DESCONTAMINACAO | 5 | 1.9% | |
| OUTRAS ATIVIDADES DE SERVICOS | 4 | 1.5% | |
| Other values (3) | 6 | 2.3% |
| Max length | 62 |
|---|---|
| Mean length | 42.626 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nu_meses_rescencia
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 4.5% |
| Missing (%) | 0.4% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.739 |
|---|---|
| Minimum | 9 |
| Maximum | 49 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 23 |
| Median | 23 |
| Q3 | 23 |
| 95-th percentile | 48 |
| Maximum | 49 |
| Range | 40 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 6.2413 |
|---|---|
| Coef of variation | 0.25229 |
| Kurtosis | 9.9073 |
| Mean | 24.739 |
| MAD | 3.1925 |
| Skewness | 3.2904 |
| Sum | 6531 |
| Variance | 38.954 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 23 | 205 | 77.4% | |
| 48 | 15 | 5.7% | |
| 26 | 13 | 4.9% | |
| 22 | 12 | 4.5% | |
| 24 | 7 | 2.6% | |
| 27 | 4 | 1.5% | |
| 21 | 3 | 1.1% | |
| 25 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 47 | 1 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | 0.4% | |
| 21 | 3 | 1.1% | |
| 22 | 12 | 4.5% | |
| 23 | 205 | 77.4% | |
| 24 | 7 | 2.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 49 | 1 | 0.4% | |
| 48 | 15 | 5.7% | |
| 47 | 1 | 0.4% | |
| 27 | 4 | 1.5% | |
| 26 | 13 | 4.9% |
percent_func_genero_fem
Numeric
| Distinct count | 261 |
|---|---|
| Unique (%) | 98.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 52.979 |
|---|---|
| Minimum | 0.36 |
| Maximum | 86.06 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.36 |
|---|---|
| 5-th percentile | 13.274 |
| Q1 | 43.38 |
| Median | 57.51 |
| Q3 | 67.71 |
| 95-th percentile | 76.994 |
| Maximum | 86.06 |
| Range | 85.7 |
| Interquartile range | 24.33 |
Descriptive statistics
| Standard deviation | 19.045 |
|---|---|
| Coef of variation | 0.35948 |
| Kurtosis | 0.12131 |
| Mean | 52.979 |
| MAD | 15.197 |
| Skewness | -0.85478 |
| Sum | 14040 |
| Variance | 362.7 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 63.38 | 2 | 0.8% | |
| 72.93 | 2 | 0.8% | |
| 69.21 | 2 | 0.8% | |
| 50 | 2 | 0.8% | |
| 68.02 | 1 | 0.4% | |
| 49.35 | 1 | 0.4% | |
| 52.31 | 1 | 0.4% | |
| 68.63 | 1 | 0.4% | |
| 63.36 | 1 | 0.4% | |
| 74.03 | 1 | 0.4% | |
| Other values (251) | 251 | 94.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.36 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 3.47 | 1 | 0.4% | |
| 4.74 | 1 | 0.4% | |
| 4.98 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 86.06 | 1 | 0.4% | |
| 84.44 | 1 | 0.4% | |
| 83.22 | 1 | 0.4% | |
| 83.1 | 1 | 0.4% | |
| 82.91 | 1 | 0.4% |
percent_func_genero_masc
Numeric
| Distinct count | 261 |
|---|---|
| Unique (%) | 98.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.021 |
|---|---|
| Minimum | 13.94 |
| Maximum | 99.64 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 13.94 |
|---|---|
| 5-th percentile | 23.006 |
| Q1 | 32.29 |
| Median | 42.49 |
| Q3 | 56.62 |
| 95-th percentile | 86.726 |
| Maximum | 99.64 |
| Range | 85.7 |
| Interquartile range | 24.33 |
Descriptive statistics
| Standard deviation | 19.045 |
|---|---|
| Coef of variation | 0.40503 |
| Kurtosis | 0.12131 |
| Mean | 47.021 |
| MAD | 15.197 |
| Skewness | 0.85478 |
| Sum | 12460 |
| Variance | 362.7 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 27.07 | 2 | 0.8% | |
| 36.62 | 2 | 0.8% | |
| 30.79 | 2 | 0.8% | |
| 50 | 2 | 0.8% | |
| 52.76 | 1 | 0.4% | |
| 16.78 | 1 | 0.4% | |
| 64.01 | 1 | 0.4% | |
| 74.22 | 1 | 0.4% | |
| 36.64 | 1 | 0.4% | |
| 50.65 | 1 | 0.4% | |
| Other values (251) | 251 | 94.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 13.94 | 1 | 0.4% | |
| 15.56 | 1 | 0.4% | |
| 16.78 | 1 | 0.4% | |
| 16.9 | 1 | 0.4% | |
| 17.09 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 99.64 | 1 | 0.4% | |
| 97 | 1 | 0.4% | |
| 96.53 | 1 | 0.4% | |
| 95.26 | 1 | 0.4% | |
| 95.02 | 1 | 0.4% |
qt_admitidos
Numeric
| Distinct count | 241 |
|---|---|
| Unique (%) | 90.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 915.86 |
|---|---|
| Minimum | 83 |
| Maximum | 7961 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 83 |
|---|---|
| 5-th percentile | 177 |
| Q1 | 355 |
| Median | 582 |
| Q3 | 983 |
| 95-th percentile | 2839.4 |
| Maximum | 7961 |
| Range | 7878 |
| Interquartile range | 628 |
Descriptive statistics
| Standard deviation | 1092.2 |
|---|---|
| Coef of variation | 1.1925 |
| Kurtosis | 16.82 |
| Mean | 915.86 |
| MAD | 641.17 |
| Skewness | 3.6757 |
| Sum | 2.427e+05 |
| Variance | 1.1929e+06 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 246 | 2 | 0.8% | |
| 582 | 2 | 0.8% | |
| 1044 | 2 | 0.8% | |
| 410 | 2 | 0.8% | |
| 355 | 2 | 0.8% | |
| 1484 | 2 | 0.8% | |
| 1160 | 2 | 0.8% | |
| 1212 | 2 | 0.8% | |
| 340 | 2 | 0.8% | |
| 243 | 2 | 0.8% | |
| Other values (231) | 245 | 92.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 83 | 1 | 0.4% | |
| 96 | 1 | 0.4% | |
| 120 | 1 | 0.4% | |
| 130 | 1 | 0.4% | |
| 136 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7961 | 1 | 0.4% | |
| 7803 | 1 | 0.4% | |
| 6262 | 1 | 0.4% | |
| 6103 | 1 | 0.4% | |
| 5340 | 1 | 0.4% |
qt_admitidos_12meses
Numeric
| Distinct count | 73 |
|---|---|
| Unique (%) | 27.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 28.064 |
|---|---|
| Minimum | 0 |
| Maximum | 782 |
| Zeros (%) | 61.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 27 |
| 95-th percentile | 132.2 |
| Maximum | 782 |
| Range | 782 |
| Interquartile range | 27 |
Descriptive statistics
| Standard deviation | 73.041 |
|---|---|
| Coef of variation | 2.6026 |
| Kurtosis | 48.796 |
| Mean | 28.064 |
| MAD | 38.542 |
| Skewness | 5.9088 |
| Sum | 7437 |
| Variance | 5335 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 162 | 61.1% | |
| 35 | 3 | 1.1% | |
| 8 | 3 | 1.1% | |
| 1 | 3 | 1.1% | |
| 18 | 3 | 1.1% | |
| 87 | 3 | 1.1% | |
| 13 | 3 | 1.1% | |
| 12 | 3 | 1.1% | |
| 74 | 2 | 0.8% | |
| 14 | 2 | 0.8% | |
| Other values (63) | 78 | 29.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 162 | 61.1% | |
| 1 | 3 | 1.1% | |
| 2 | 2 | 0.8% | |
| 4 | 1 | 0.4% | |
| 6 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 782 | 1 | 0.4% | |
| 465 | 1 | 0.4% | |
| 332 | 1 | 0.4% | |
| 259 | 1 | 0.4% | |
| 256 | 1 | 0.4% |
qt_alteracao_socio_180d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_365d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_90d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_total
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_art
Numeric
| Distinct count | 39 |
|---|---|
| Unique (%) | 14.7% |
| Missing (%) | 50.9% |
| Missing (n) | 135 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.515 |
|---|---|
| Minimum | 1 |
| Maximum | 912 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2.25 |
| Median | 6 |
| Q3 | 14 |
| 95-th percentile | 44 |
| Maximum | 912 |
| Range | 911 |
| Interquartile range | 11.75 |
Descriptive statistics
| Standard deviation | 87.8 |
|---|---|
| Coef of variation | 4.0808 |
| Kurtosis | 86.519 |
| Mean | 21.515 |
| MAD | 25.256 |
| Skewness | 8.9824 |
| Sum | 2797 |
| Variance | 7708.9 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 20 | 7.5% | |
| 3 | 13 | 4.9% | |
| 2 | 13 | 4.9% | |
| 6 | 10 | 3.8% | |
| 5 | 9 | 3.4% | |
| 13 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 4 | 5 | 1.9% | |
| 14 | 4 | 1.5% | |
| 12 | 3 | 1.1% | |
| Other values (28) | 41 | 15.5% | |
| (Missing) | 135 | 50.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 20 | 7.5% | |
| 2 | 13 | 4.9% | |
| 3 | 13 | 4.9% | |
| 4 | 5 | 1.9% | |
| 5 | 9 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 912 | 1 | 0.4% | |
| 426 | 1 | 0.4% | |
| 88 | 1 | 0.4% | |
| 51 | 2 | 0.8% | |
| 45 | 1 | 0.4% |
qt_coligadas
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.9737 |
|---|---|
| Minimum | 1 |
| Maximum | 57 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 6 |
| 95-th percentile | 36.5 |
| Maximum | 57 |
| Range | 56 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 11.03 |
|---|---|
| Coef of variation | 1.5816 |
| Kurtosis | 7.0833 |
| Mean | 6.9737 |
| MAD | 7.2749 |
| Skewness | 2.6335 |
| Sum | 530 |
| Variance | 121.65 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 14 | 5.3% | |
| 3 | 7 | 2.6% | |
| 6 | 7 | 2.6% | |
| 4 | 3 | 1.1% | |
| 15 | 2 | 0.8% | |
| 8 | 2 | 0.8% | |
| 17 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 36 | 1 | 0.4% | |
| Other values (10) | 10 | 3.8% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 14 | 5.3% | |
| 3 | 7 | 2.6% | |
| 4 | 3 | 1.1% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 57 | 1 | 0.4% | |
| 40 | 1 | 0.4% | |
| 39 | 1 | 0.4% | |
| 38 | 1 | 0.4% | |
| 36 | 1 | 0.4% |
qt_coligados
Highly correlated
This variable is highly correlated with qt_coligadas and should be ignored for analysis
| Correlation | 1 |
|---|
qt_coligados_agropecuaria
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 3 |
| 2 | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 70 | 26.4% | |
| 1 | 3 | 1.1% | |
| 2 | 2 | 0.8% | |
| 4 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_atividade_alto
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_baixo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_inativo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_medio
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_mt_baixo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_ativo
Highly correlated
This variable is highly correlated with qt_coligados and should be ignored for analysis
| Correlation | 0.99975 |
|---|
qt_coligados_baixada
Highly correlated
This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.97185 |
|---|
qt_coligados_ccivil
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 5 |
| 2 | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 2 | 2 | 0.8% | |
| 3 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_centro
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.31579 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 25.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.2983 |
|---|---|
| Coef of variation | 4.1113 |
| Kurtosis | 25.694 |
| Mean | 0.31579 |
| MAD | 0.5651 |
| Skewness | 5.0173 |
| Sum | 24 |
| Variance | 1.6856 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 8 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 4 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 1 | 5 | 1.9% | |
| 0 | 68 | 25.7% |
qt_coligados_comercio
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.0921 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros (%) | 17.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 3.1546 |
|---|---|
| Coef of variation | 2.8885 |
| Kurtosis | 53.169 |
| Mean | 1.0921 |
| MAD | 1.356 |
| Skewness | 6.8226 |
| Sum | 83 |
| Variance | 9.9514 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46 | 17.4% | |
| 1 | 14 | 5.3% | |
| 2 | 9 | 3.4% | |
| 4 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 26 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46 | 17.4% | |
| 1 | 14 | 5.3% | |
| 2 | 9 | 3.4% | |
| 3 | 2 | 0.8% | |
| 4 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 26 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 4 | 2 | 0.8% | |
| 3 | 2 | 0.8% |
qt_coligados_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_exterior
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_inapta
Highly correlated
This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.97185 |
|---|
qt_coligados_industria
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | 3.0% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.44737 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 23.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.25 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.4913 |
|---|---|
| Coef of variation | 3.3334 |
| Kurtosis | 25.378 |
| Mean | 0.44737 |
| MAD | 0.74169 |
| Skewness | 4.7623 |
| Sum | 34 |
| Variance | 2.2239 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 63 | 23.8% | |
| 1 | 8 | 3.0% | |
| 10 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 63 | 23.8% | |
| 1 | 8 | 3.0% | |
| 2 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 1 | 0.4% |
qt_coligados_ltda
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.26316 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 26.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.1704 |
|---|---|
| Coef of variation | 4.4475 |
| Kurtosis | 32.877 |
| Mean | 0.26316 |
| MAD | 0.47784 |
| Skewness | 5.616 |
| Sum | 20 |
| Variance | 1.3698 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 69 | 26.0% | |
| 1 | 4 | 1.5% | |
| 2 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 69 | 26.0% | |
| 1 | 4 | 1.5% | |
| 2 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 1 | 4 | 1.5% | |
| 0 | 69 | 26.0% |
qt_coligados_matriz
Highly correlated
This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis
| Correlation | 0.9997 |
|---|
qt_coligados_me
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_mei
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 75 | 28.3% | |
| 1 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
qt_coligados_nordeste
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.6184 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros (%) | 11.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2.25 |
| 95-th percentile | 9.75 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range | 2.25 |
Descriptive statistics
| Standard deviation | 5.5377 |
|---|---|
| Coef of variation | 2.1149 |
| Kurtosis | 20.65 |
| Mean | 2.6184 |
| MAD | 3.0066 |
| Skewness | 4.2072 |
| Sum | 199 |
| Variance | 30.666 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 31 | 11.7% | |
| 1 | 17 | 6.4% | |
| 2 | 9 | 3.4% | |
| 6 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 36 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 12 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| Other values (3) | 3 | 1.1% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 31 | 11.7% | |
| 1 | 17 | 6.4% | |
| 2 | 9 | 3.4% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 36 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 17 | 1 | 0.4% | |
| 12 | 1 | 0.4% | |
| 9 | 1 | 0.4% |
qt_coligados_norte
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.8816 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros (%) | 14.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 11.75 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 7.5753 |
|---|---|
| Coef of variation | 2.6289 |
| Kurtosis | 26.258 |
| Mean | 2.8816 |
| MAD | 3.7898 |
| Skewness | 4.7758 |
| Sum | 219 |
| Variance | 57.386 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 39 | 14.7% | |
| 1 | 14 | 5.3% | |
| 2 | 6 | 2.3% | |
| 5 | 3 | 1.1% | |
| 3 | 3 | 1.1% | |
| 4 | 2 | 0.8% | |
| 9 | 2 | 0.8% | |
| 6 | 2 | 0.8% | |
| 22 | 1 | 0.4% | |
| 11 | 1 | 0.4% | |
| Other values (3) | 3 | 1.1% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 39 | 14.7% | |
| 1 | 14 | 5.3% | |
| 2 | 6 | 2.3% | |
| 3 | 3 | 1.1% | |
| 4 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52 | 1 | 0.4% | |
| 32 | 1 | 0.4% | |
| 22 | 1 | 0.4% | |
| 14 | 1 | 0.4% | |
| 11 | 1 | 0.4% |
qt_coligados_nula
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_sa
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.53947 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 24.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.7005 |
|---|---|
| Coef of variation | 3.1522 |
| Kurtosis | 16.01 |
| Mean | 0.53947 |
| MAD | 0.90859 |
| Skewness | 3.882 |
| Sum | 41 |
| Variance | 2.8918 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 64 | 24.2% | |
| 1 | 6 | 2.3% | |
| 4 | 3 | 1.1% | |
| 10 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 64 | 24.2% | |
| 1 | 6 | 2.3% | |
| 4 | 3 | 1.1% | |
| 6 | 1 | 0.4% | |
| 7 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 4 | 3 | 1.1% | |
| 1 | 6 | 2.3% |
qt_coligados_serviço
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.92884 |
|---|
qt_coligados_sudeste
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.0132 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros (%) | 24.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3.75 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.0677 |
|---|---|
| Coef of variation | 4.0149 |
| Kurtosis | 31.879 |
| Mean | 1.0132 |
| MAD | 1.7334 |
| Skewness | 5.4761 |
| Sum | 77 |
| Variance | 16.546 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 65 | 24.5% | |
| 2 | 4 | 1.5% | |
| 3 | 2 | 0.8% | |
| 1 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 28 | 1 | 0.4% | |
| 20 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 65 | 24.5% | |
| 1 | 1 | 0.4% | |
| 2 | 4 | 1.5% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28 | 1 | 0.4% | |
| 20 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 3 | 2 | 0.8% |
qt_coligados_sul
Highly correlated
This variable is highly correlated with qt_coligados_baixada and should be ignored for analysis
| Correlation | 0.96129 |
|---|
qt_coligados_suspensa
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_desligados
Highly correlated
This variable is highly correlated with qt_admitidos and should be ignored for analysis
| Correlation | 0.90561 |
|---|
qt_desligados_12meses
Numeric
| Distinct count | 73 |
|---|---|
| Unique (%) | 27.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 23.921 |
|---|---|
| Minimum | 0 |
| Maximum | 394 |
| Zeros (%) | 60.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 21 |
| 95-th percentile | 125.6 |
| Maximum | 394 |
| Range | 394 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 59.93 |
|---|---|
| Coef of variation | 2.5054 |
| Kurtosis | 18.15 |
| Mean | 23.921 |
| MAD | 32.957 |
| Skewness | 4.0203 |
| Sum | 6339 |
| Variance | 3591.6 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 159 | 60.0% | |
| 27 | 6 | 2.3% | |
| 9 | 5 | 1.9% | |
| 8 | 4 | 1.5% | |
| 22 | 4 | 1.5% | |
| 29 | 3 | 1.1% | |
| 7 | 3 | 1.1% | |
| 1 | 3 | 1.1% | |
| 11 | 3 | 1.1% | |
| 5 | 3 | 1.1% | |
| Other values (63) | 72 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 159 | 60.0% | |
| 1 | 3 | 1.1% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 394 | 1 | 0.4% | |
| 379 | 1 | 0.4% | |
| 366 | 1 | 0.4% | |
| 345 | 1 | 0.4% | |
| 277 | 1 | 0.4% |
qt_ex_funcionarios
Highly correlated
This variable is highly correlated with qt_desligados and should be ignored for analysis
| Correlation | 1 |
|---|
qt_filiais
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.5547 |
|---|---|
| Minimum | 0 |
| Maximum | 172 |
| Zeros (%) | 58.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 9.8 |
| Maximum | 172 |
| Range | 172 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 12.01 |
|---|---|
| Coef of variation | 4.7011 |
| Kurtosis | 153.03 |
| Mean | 2.5547 |
| MAD | 3.6816 |
| Skewness | 11.409 |
| Sum | 677 |
| Variance | 144.24 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 155 | 58.5% | |
| 1 | 53 | 20.0% | |
| 2 | 17 | 6.4% | |
| 3 | 10 | 3.8% | |
| 5 | 4 | 1.5% | |
| 7 | 3 | 1.1% | |
| 4 | 3 | 1.1% | |
| 10 | 3 | 1.1% | |
| 12 | 2 | 0.8% | |
| 9 | 2 | 0.8% | |
| Other values (11) | 13 | 4.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 155 | 58.5% | |
| 1 | 53 | 20.0% | |
| 2 | 17 | 6.4% | |
| 3 | 10 | 3.8% | |
| 4 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 172 | 1 | 0.4% | |
| 51 | 1 | 0.4% | |
| 49 | 1 | 0.4% | |
| 42 | 1 | 0.4% | |
| 33 | 1 | 0.4% |
qt_funcionarios
Numeric
| Distinct count | 231 |
|---|---|
| Unique (%) | 87.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 468.6 |
|---|---|
| Minimum | 68 |
| Maximum | 3919 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 68 |
|---|---|
| 5-th percentile | 116 |
| Q1 | 188 |
| Median | 313 |
| Q3 | 539 |
| 95-th percentile | 1321.2 |
| Maximum | 3919 |
| Range | 3851 |
| Interquartile range | 351 |
Descriptive statistics
| Standard deviation | 494.57 |
|---|---|
| Coef of variation | 1.0554 |
| Kurtosis | 16.016 |
| Mean | 468.6 |
| MAD | 310.06 |
| Skewness | 3.4417 |
| Sum | 1.2418e+05 |
| Variance | 2.446e+05 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 349 | 2 | 0.8% | |
| 353 | 2 | 0.8% | |
| 378 | 2 | 0.8% | |
| 677 | 2 | 0.8% | |
| 219 | 2 | 0.8% | |
| 188 | 2 | 0.8% | |
| 186 | 2 | 0.8% | |
| 199 | 2 | 0.8% | |
| 317 | 2 | 0.8% | |
| 212 | 2 | 0.8% | |
| Other values (221) | 245 | 92.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 68 | 1 | 0.4% | |
| 76 | 1 | 0.4% | |
| 82 | 1 | 0.4% | |
| 83 | 1 | 0.4% | |
| 85 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3919 | 1 | 0.4% | |
| 3172 | 1 | 0.4% | |
| 3104 | 1 | 0.4% | |
| 2669 | 1 | 0.4% | |
| 1936 | 1 | 0.4% |
qt_funcionarios_12meses
Highly correlated
This variable is highly correlated with qt_funcionarios and should be ignored for analysis
| Correlation | 0.99487 |
|---|
qt_funcionarios_24meses
Highly correlated
This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis
| Correlation | 0.96889 |
|---|
qt_funcionarios_coligados
Numeric
| Distinct count | 53 |
|---|---|
| Unique (%) | 20.0% |
| Missing (%) | 76.2% |
| Missing (n) | 202 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 551.03 |
|---|---|
| Minimum | 0 |
| Maximum | 4770 |
| Zeros (%) | 1.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.5 |
| Median | 112 |
| Q3 | 510.5 |
| 95-th percentile | 3090.1 |
| Maximum | 4770 |
| Range | 4770 |
| Interquartile range | 500 |
Descriptive statistics
| Standard deviation | 1079.4 |
|---|---|
| Coef of variation | 1.9588 |
| Kurtosis | 7.1191 |
| Mean | 551.03 |
| MAD | 685.38 |
| Skewness | 2.7314 |
| Sum | 34715 |
| Variance | 1.1651e+06 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5 | 1.9% | |
| 4 | 3 | 1.1% | |
| 23 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 1 | 2 | 0.8% | |
| 11 | 2 | 0.8% | |
| 617 | 2 | 0.8% | |
| 54 | 1 | 0.4% | |
| 152 | 1 | 0.4% | |
| 312 | 1 | 0.4% | |
| Other values (42) | 42 | 15.8% | |
| (Missing) | 202 | 76.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5 | 1.9% | |
| 1 | 2 | 0.8% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4770 | 1 | 0.4% | |
| 4463 | 1 | 0.4% | |
| 4124 | 1 | 0.4% | |
| 3183 | 1 | 0.4% | |
| 2254 | 1 | 0.4% |
qt_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with qt_coligados_inapta and should be ignored for analysis
| Correlation | 0.92314 |
|---|
qt_funcionarios_grupo
Highly correlated
This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis
| Correlation | 0.9503 |
|---|
qt_ramos_coligados
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.93462 |
|---|
qt_regioes_coligados
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.4079 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.91181 |
|---|---|
| Coef of variation | 0.64764 |
| Kurtosis | 4.7184 |
| Mean | 1.4079 |
| MAD | 0.64404 |
| Skewness | 2.3399 |
| Sum | 107 |
| Variance | 0.8314 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 60 | 22.6% | |
| 2 | 7 | 2.6% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 60 | 22.6% | |
| 2 | 7 | 2.6% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.4% | |
| 4 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 2 | 7 | 2.6% | |
| 1 | 60 | 22.6% |
qt_socios
Highly correlated
This variable is highly correlated with qt_coligados_mei and should be ignored for analysis
| Correlation | 0.98995 |
|---|
qt_socios_coligados
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | 8.7% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 12.763 |
|---|---|
| Minimum | 1 |
| Maximum | 138 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 12 |
| 95-th percentile | 58.5 |
| Maximum | 138 |
| Range | 137 |
| Interquartile range | 11 |
Descriptive statistics
| Standard deviation | 26.831 |
|---|---|
| Coef of variation | 2.1022 |
| Kurtosis | 12.263 |
| Mean | 12.763 |
| MAD | 15.086 |
| Skewness | 3.4887 |
| Sum | 970 |
| Variance | 719.92 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 4 | 5 | 1.9% | |
| 3 | 4 | 1.5% | |
| 5 | 4 | 1.5% | |
| 14 | 3 | 1.1% | |
| 6 | 3 | 1.1% | |
| 24 | 2 | 0.8% | |
| 28 | 2 | 0.8% | |
| 12 | 2 | 0.8% | |
| Other values (12) | 14 | 5.3% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 4 | 1.5% | |
| 4 | 5 | 1.9% | |
| 5 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 138 | 1 | 0.4% | |
| 128 | 1 | 0.4% | |
| 107 | 1 | 0.4% | |
| 96 | 1 | 0.4% | |
| 46 | 1 | 0.4% |
qt_socios_feminino
Highly correlated
This variable is highly correlated with qt_socios and should be ignored for analysis
| Correlation | 0.99365 |
|---|
qt_socios_masculino
Highly correlated
This variable is highly correlated with qt_socios_feminino and should be ignored for analysis
| Correlation | 0.99163 |
|---|
qt_socios_pep
Highly correlated
This variable is highly correlated with qt_socios_masculino and should be ignored for analysis
| Correlation | 0.99546 |
|---|
qt_socios_pf
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.99609 |
|---|
qt_socios_pj
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 63.0% |
| Missing (n) | 167 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2551 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 31.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.73655 |
|---|---|
| Coef of variation | 2.8873 |
| Kurtosis | 19.407 |
| Mean | 0.2551 |
| MAD | 0.43211 |
| Skewness | 3.9797 |
| Sum | 25 |
| Variance | 0.5425 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 83 | 31.3% | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| (Missing) | 167 | 63.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 83 | 31.3% | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 3 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 4 | 1.5% | |
| 1 | 9 | 3.4% | |
| 0 | 83 | 31.3% |
qt_socios_pj_ativos
Highly correlated
This variable is highly correlated with qt_socios_pj and should be ignored for analysis
| Correlation | 1 |
|---|
qt_socios_pj_baixados
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_pj_inaptos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_pj_nulos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_pj_suspensos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_st_regular
Highly correlated
This variable is highly correlated with qt_socios_pf and should be ignored for analysis
| Correlation | 0.99836 |
|---|
qt_socios_st_suspensa
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_ufs_coligados
Highly correlated
This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis
| Correlation | 0.90264 |
|---|
setor
Constant
This variable is constant and should be ignored for analysis
| Constant value | SERVIÇO |
|---|
sg_uf
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MA | |
|---|---|
| PI | |
| RN | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| MA | 74 | 27.9% | |
| PI | 52 | 19.6% | |
| RN | 51 | 19.2% | |
| AM | 43 | 16.2% | |
| AC | 23 | 8.7% | |
| RO | 22 | 8.3% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sg_uf_matriz
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MA | |
|---|---|
| PI | |
| RN | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| MA | 74 | 27.9% | |
| PI | 52 | 19.6% | |
| RN | 51 | 19.2% | |
| AM | 43 | 16.2% | |
| AC | 23 | 8.7% | |
| RO | 22 | 8.3% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sum_faturamento_estimado_coligadas
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.90166 |
|---|
total
Highly correlated
This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis
| Correlation | 0.97431 |
|---|
total_filiais_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.93546 |
|---|
tx_crescimento_12meses
Numeric
| Distinct count | 104 |
|---|---|
| Unique (%) | 39.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 51.831 |
|---|---|
| Minimum | -29.633 |
| Maximum | 12700 |
| Zeros (%) | 60.8% |
Quantile statistics
| Minimum | -29.633 |
|---|---|
| 5-th percentile | -6.5096 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 29.534 |
| Maximum | 12700 |
| Range | 12730 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 780.17 |
|---|---|
| Coef of variation | 15.052 |
| Kurtosis | 264.64 |
| Mean | 51.831 |
| MAD | 97.851 |
| Skewness | 16.263 |
| Sum | 13735 |
| Variance | 6.0867e+05 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 161 | 60.8% | |
| 6.383 | 2 | 0.8% | |
| -11.377 | 1 | 0.4% | |
| -2.7523 | 1 | 0.4% | |
| 13.711 | 1 | 0.4% | |
| 75.61 | 1 | 0.4% | |
| 27.139 | 1 | 0.4% | |
| 40.991 | 1 | 0.4% | |
| -9.8086 | 1 | 0.4% | |
| -1.4563 | 1 | 0.4% | |
| Other values (94) | 94 | 35.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -29.633 | 1 | 0.4% | |
| -25.879 | 1 | 0.4% | |
| -14.605 | 1 | 0.4% | |
| -14.518 | 1 | 0.4% | |
| -13.58 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12700 | 1 | 0.4% | |
| 246.15 | 1 | 0.4% | |
| 100 | 1 | 0.4% | |
| 77.647 | 1 | 0.4% | |
| 75.61 | 1 | 0.4% |
tx_crescimento_24meses
Highly correlated
This variable is highly correlated with tx_crescimento_12meses and should be ignored for analysis
| Correlation | 0.99596 |
|---|
tx_rotatividade
Numeric
| Distinct count | 106 |
|---|---|
| Unique (%) | 40.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.5663 |
|---|---|
| Minimum | 0 |
| Maximum | 101.09 |
| Zeros (%) | 60.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 11.394 |
| 95-th percentile | 28.694 |
| Maximum | 101.09 |
| Range | 101.09 |
| Interquartile range | 11.394 |
Descriptive statistics
| Standard deviation | 11.828 |
|---|---|
| Coef of variation | 1.8013 |
| Kurtosis | 16.077 |
| Mean | 6.5663 |
| MAD | 8.6113 |
| Skewness | 3.0632 |
| Sum | 1740.1 |
| Variance | 139.9 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 160 | 60.4% | |
| 9.037 | 1 | 0.4% | |
| 36.066 | 1 | 0.4% | |
| 40.26 | 1 | 0.4% | |
| 2.5751 | 1 | 0.4% | |
| 4.5326 | 1 | 0.4% | |
| 18.736 | 1 | 0.4% | |
| 34.302 | 1 | 0.4% | |
| 4.8889 | 1 | 0.4% | |
| 9.901 | 1 | 0.4% | |
| Other values (96) | 96 | 36.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 160 | 60.4% | |
| 0.13387 | 1 | 0.4% | |
| 0.14316 | 1 | 0.4% | |
| 0.56117 | 1 | 0.4% | |
| 0.82988 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 101.09 | 1 | 0.4% | |
| 55.352 | 1 | 0.4% | |
| 42.667 | 1 | 0.4% | |
| 40.26 | 1 | 0.4% | |
| 39.184 | 1 | 0.4% |
vl_faturamento_estimado_aux
Numeric
| Distinct count | 248 |
|---|---|
| Unique (%) | 93.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.0801e+08 |
|---|---|
| Minimum | 2.004e+07 |
| Maximum | 2.0116e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.004e+07 |
|---|---|
| 5-th percentile | 2.2585e+07 |
| Q1 | 3.0601e+07 |
| Median | 5.1001e+07 |
| Q3 | 9.9786e+07 |
| 95-th percentile | 3.7865e+08 |
| Maximum | 2.0116e+09 |
| Range | 1.9916e+09 |
| Interquartile range | 6.9186e+07 |
Descriptive statistics
| Standard deviation | 1.9263e+08 |
|---|---|
| Coef of variation | 1.7835 |
| Kurtosis | 45.081 |
| Mean | 1.0801e+08 |
| MAD | 9.4175e+07 |
| Skewness | 5.8515 |
| Sum | 2.8622e+10 |
| Variance | 3.7105e+16 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.4625e+07 | 3 | 1.1% | |
| 2.4882e+07 | 2 | 0.8% | |
| 4.9661e+07 | 2 | 0.8% | |
| 4.5283e+07 | 2 | 0.8% | |
| 2.4419e+07 | 2 | 0.8% | |
| 2.3337e+07 | 2 | 0.8% | |
| 1.174e+08 | 2 | 0.8% | |
| 2.3388e+07 | 2 | 0.8% | |
| 2.7819e+07 | 2 | 0.8% | |
| 2.787e+07 | 2 | 0.8% | |
| Other values (238) | 244 | 92.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.004e+07 | 1 | 0.4% | |
| 2.0246e+07 | 1 | 0.4% | |
| 2.0606e+07 | 2 | 0.8% | |
| 2.0709e+07 | 1 | 0.4% | |
| 2.0761e+07 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.0116e+09 | 1 | 0.4% | |
| 1.3759e+09 | 1 | 0.4% | |
| 9.3038e+08 | 1 | 0.4% | |
| 9.1462e+08 | 1 | 0.4% | |
| 7.5559e+08 | 1 | 0.4% |
vl_faturamento_estimado_grupo_aux
Highly correlated
This variable is highly correlated with vl_faturamento_estimado_aux and should be ignored for analysis
| Correlation | 0.9811 |
|---|
vl_folha_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis
| Correlation | 0.96112 |
|---|
vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with vl_folha_coligados and should be ignored for analysis
| Correlation | 0.94289 |
|---|
vl_frota
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.91388 |
|---|
vl_idade_maxima_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.037 |
|---|---|
| Minimum | 0.76112 |
| Maximum | 52.282 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.76112 |
|---|---|
| 5-th percentile | 3.2296 |
| Q1 | 9.3388 |
| Median | 27.8 |
| Q3 | 35.418 |
| 95-th percentile | 47.397 |
| Maximum | 52.282 |
| Range | 51.521 |
| Interquartile range | 26.079 |
Descriptive statistics
| Standard deviation | 16.29 |
|---|---|
| Coef of variation | 0.67769 |
| Kurtosis | -1.2346 |
| Mean | 24.037 |
| MAD | 14.082 |
| Skewness | 0.14165 |
| Sum | 360.56 |
| Variance | 265.36 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 27.8 | 1 | 0.4% | |
| 32.942 | 1 | 0.4% | |
| 7.8823 | 1 | 0.4% | |
| 18.338 | 1 | 0.4% | |
| 52.282 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% | |
| 10.795 | 1 | 0.4% | |
| 37.895 | 1 | 0.4% | |
| 14.283 | 1 | 0.4% | |
| 40.983 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.76112 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% | |
| 6.2971 | 1 | 0.4% | |
| 7.8823 | 1 | 0.4% | |
| 10.795 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52.282 | 1 | 0.4% | |
| 45.303 | 1 | 0.4% | |
| 40.983 | 1 | 0.4% | |
| 37.895 | 1 | 0.4% | |
| 32.942 | 1 | 0.4% |
vl_idade_media_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17.757 |
|---|---|
| Minimum | 0.76112 |
| Maximum | 40.983 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.76112 |
|---|---|
| 5-th percentile | 3.2296 |
| Q1 | 9.3388 |
| Median | 15.051 |
| Q3 | 27.468 |
| 95-th percentile | 35.354 |
| Maximum | 40.983 |
| Range | 40.222 |
| Interquartile range | 18.129 |
Descriptive statistics
| Standard deviation | 11.979 |
|---|---|
| Coef of variation | 0.67464 |
| Kurtosis | -0.72067 |
| Mean | 17.757 |
| MAD | 9.7264 |
| Skewness | 0.54425 |
| Sum | 266.35 |
| Variance | 143.51 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32.942 | 1 | 0.4% | |
| 7.8823 | 1 | 0.4% | |
| 18.338 | 1 | 0.4% | |
| 15.051 | 1 | 0.4% | |
| 32.29 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% | |
| 15.938 | 1 | 0.4% | |
| 10.795 | 1 | 0.4% | |
| 14.283 | 1 | 0.4% | |
| 23.574 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.76112 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% | |
| 6.2971 | 1 | 0.4% | |
| 7.8823 | 1 | 0.4% | |
| 10.795 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.983 | 1 | 0.4% | |
| 32.942 | 1 | 0.4% | |
| 32.29 | 1 | 0.4% | |
| 31.362 | 1 | 0.4% | |
| 23.574 | 1 | 0.4% |
vl_idade_minima_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.76 |
|---|---|
| Minimum | 0.65982 |
| Maximum | 40.983 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.65982 |
|---|---|
| 5-th percentile | 0.73073 |
| Q1 | 3.9576 |
| Median | 10.795 |
| Q3 | 18.843 |
| 95-th percentile | 35.354 |
| Maximum | 40.983 |
| Range | 40.323 |
| Interquartile range | 14.886 |
Descriptive statistics
| Standard deviation | 12.626 |
|---|---|
| Coef of variation | 0.91758 |
| Kurtosis | 0.031974 |
| Mean | 13.76 |
| MAD | 9.9599 |
| Skewness | 1.0058 |
| Sum | 206.39 |
| Variance | 159.4 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32.942 | 1 | 0.4% | |
| 7.8823 | 1 | 0.4% | |
| 12.298 | 1 | 0.4% | |
| 18.338 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% | |
| 0.65982 | 1 | 0.4% | |
| 10.795 | 1 | 0.4% | |
| 14.283 | 1 | 0.4% | |
| 40.983 | 1 | 0.4% | |
| 31.362 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.65982 | 1 | 0.4% | |
| 0.76112 | 1 | 0.4% | |
| 2.527 | 1 | 0.4% | |
| 3.6277 | 1 | 0.4% | |
| 4.2875 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.983 | 1 | 0.4% | |
| 32.942 | 1 | 0.4% | |
| 31.362 | 1 | 0.4% | |
| 19.348 | 1 | 0.4% | |
| 18.338 | 1 | 0.4% |
vl_potenc_cons_oleo_gas
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 91.7% |
| Missing (n) | 243 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 101.91 |
|---|---|
| Minimum | 1 |
| Maximum | 430 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.05 |
| Q1 | 21.25 |
| Median | 45 |
| Q3 | 163.5 |
| 95-th percentile | 368.45 |
| Maximum | 430 |
| Range | 429 |
| Interquartile range | 142.25 |
Descriptive statistics
| Standard deviation | 125.44 |
|---|---|
| Coef of variation | 1.2309 |
| Kurtosis | 1.3393 |
| Mean | 101.91 |
| MAD | 100.51 |
| Skewness | 1.4858 |
| Sum | 2242 |
| Variance | 15736 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32 | 2 | 0.8% | |
| 45 | 2 | 0.8% | |
| 22 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 216 | 1 | 0.4% | |
| 374 | 1 | 0.4% | |
| 226 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 138 | 1 | 0.4% | |
| 172 | 1 | 0.4% | |
| Other values (10) | 10 | 3.8% | |
| (Missing) | 243 | 91.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 430 | 1 | 0.4% | |
| 374 | 1 | 0.4% | |
| 263 | 1 | 0.4% | |
| 226 | 1 | 0.4% | |
| 216 | 1 | 0.4% |
vl_total_tancagem
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 96.2% |
| Missing (n) | 255 |
| 15 | 7 |
|---|---|
| 45 | 1 |
| 40 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 15 | 7 | 2.6% | |
| 45 | 1 | 0.4% | |
| 40 | 1 | 0.4% | |
| 30 | 1 | 0.4% | |
| (Missing) | 255 | 96.2% |
| Max length | 4 |
|---|---|
| Mean length | 3.0377 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
vl_total_tancagem_grupo
Highly correlated
This variable is highly correlated with vl_idade_minima_socios_pj and should be ignored for analysis
| Correlation | 0.94442 |
|---|
vl_total_veiculos_antt
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
vl_total_veiculos_antt_grupo
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
vl_total_veiculos_leves
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.93282 |
|---|
vl_total_veiculos_leves_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis
| Correlation | 0.99727 |
|---|
vl_total_veiculos_pesados
Highly correlated
This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis
| Correlation | 0.9929 |
|---|
vl_total_veiculos_pesados_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_pesados and should be ignored for analysis
| Correlation | 0.99781 |
|---|
First rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 644.27 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | 117.0 | 106.0 | 522.0 | bb61c09449a1c1f8b78955d8b7a7f73599e78358993fe24b56a3e11f7d6a0bce | 45.0 | NaN | NaN | 44.0 | 107.0 | 162.0 | 161.0 | 113.0 | 69.0 | 44.0 | > 20 | 21.813699 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 259.166667 | 259.166667 | NaN | NaN | NaN | NaN | NaN | NaN | 144.663535 | 133.286943 | NaN | NaN | 40.500000 | NaN | NaN | NaN | NaN | 40.500000 | -2.466667 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | OESTE MARANHENSE | PINDARE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 26.0 | 63.36 | 36.64 | 845.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100.0 | 0.0 | 100.0 | 2 | 745.0 | 745.0 | 745.0 | NaN | NaN | 745.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 745.0 | NaN | 0.000000 | 0.000000 | 0.000000 | 141308380.0 | 144348380.0 | NaN | NaN | 275282.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5.0 | 5.0 | 2.0 | 2.0 |
| 1 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE SIMPLES LIMITADA | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 688.31 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 19.0 | 9.0 | 91.0 | 16843c9ffb920170477118933798510d8d5f00f5c56c1221773356355bded321 | 2.0 | NaN | 1.0 | 10.0 | 27.0 | 30.0 | 20.0 | 15.0 | 11.0 | 3.0 | 15 a 20 | 16.389041 | NaN | 70.0 | NaN | NaN | NaN | 70.0 | NaN | 70.0 | NaN | NaN | NaN | NaN | 149.033333 | 149.033333 | NaN | NaN | NaN | NaN | NaN | NaN | 65.942017 | 42.166782 | NaN | NaN | 4.866667 | NaN | NaN | NaN | NaN | 4.866667 | 0.000000 | NaN | NaN | ENTIDADES EMPRESARIAIS | EDUCACAO | NORTE PIAUIENSE | BAIXO PARNAIBA PIAUIENSE | EDUCACAO | 23.0 | 47.90 | 52.10 | 291.0 | 21.0 | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 172.0 | 7.0 | 172.0 | 0 | 119.0 | 104.0 | 113.0 | NaN | NaN | 119.0 | NaN | NaN | 2.0 | NaN | 1.0 | NaN | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | SERVIÇO | PI | PI | NaN | 119.0 | NaN | 14.423077 | 5.309735 | 6.250000 | 27818640.0 | 27818640.0 | NaN | NaN | 60101.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 1.0 |
| 2 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 1998-07-28 | 1881.35 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | False | NaN | NaN | 56.0 | 26.0 | 88.0 | 1b8d092daff12bed8b3c2ab93bf5df2921865a68aca185f51e31e7105abb0c48 | 73.0 | NaN | 1.0 | 7.0 | 10.0 | 11.0 | 12.0 | 9.0 | 14.0 | 33.0 | > 20 | 40.380822 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 557.866667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 284.854706 | 216.077090 | NaN | NaN | 24.200000 | NaN | NaN | NaN | NaN | 24.200000 | 0.633333 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO AMAZONENSE | MANAUS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 56.47 | 43.53 | 291.0 | 0.0 | NaN | NaN | NaN | NaN | 32.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 121.0 | 0.0 | 121.0 | 0 | 170.0 | 170.0 | 177.0 | NaN | NaN | 170.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | AM | AM | NaN | 170.0 | NaN | 0.000000 | -3.954802 | 0.000000 | 92728800.0 | 92728800.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 3 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-10-14 | 353.66 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 35.0 | 53.0 | 63.0 | 3aafa3a1f12f483740a52956af100223333d0e3c79bf2ce341896dd554e72293 | 14.0 | NaN | NaN | NaN | 8.0 | 18.0 | 29.0 | 22.0 | 31.0 | 29.0 | > 20 | 43.854795 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 506.966667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 189.020309 | 316.503220 | NaN | NaN | 31.333333 | NaN | NaN | NaN | NaN | 31.333333 | 8.733333 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO NORTE PIAUIENSE | VALENCA DO PIAUI | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 73.51 | 26.49 | 176.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.0 | 0.0 | 25.0 | 0 | 151.0 | 151.0 | 151.0 | NaN | NaN | 151.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | NaN | 151.0 | NaN | 0.000000 | 0.000000 | 0.000000 | 24418584.0 | 24418584.0 | NaN | NaN | 87223.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 2.0 | 2.0 |
| 4 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-06-11 | NaN | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | NaN | 147.0 | 82.0 | c60431fbca90067f105570e1e8a684bcd7048205bbf6c40d71c3d558626f2344 | 24.0 | NaN | NaN | 6.0 | 10.0 | 12.0 | 45.0 | 50.0 | 48.0 | 34.0 | > 20 | 43.865753 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 556.833333 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 238.418341 | 146.443381 | NaN | NaN | 23.200000 | NaN | NaN | NaN | NaN | 34.033333 | -0.066667 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | AGRESTE POTIGUAR | BAIXA VERDE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 72.93 | 27.07 | 836.0 | 0.0 | NaN | NaN | NaN | NaN | 4.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 607.0 | 0.0 | 606.0 | 1 | 229.0 | 229.0 | 418.0 | NaN | NaN | 229.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 229.0 | NaN | 0.000000 | -45.215311 | 0.000000 | 38585484.0 | 38585484.0 | NaN | NaN | 23412.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 |
| 5 | 634.266667 | NaN | 145.700000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ASSOCIACAO PRIVADA | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 1016.48 | 10770780.0 | 30684070.0 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 11.0 | 15.0 | 144.0 | 5de08033561948a226f8ba8f8668a4ff4123be8ea7114dce5d7c0d74f61837bf | 13.0 | NaN | 2.0 | 9.0 | 29.0 | 28.0 | 26.0 | 35.0 | 18.0 | 10.0 | > 20 | 47.087671 | 634.266667 | 40.0 | 389.983333 | 389.983333 | NaN | 38.0 | 145.700000 | 36.0 | 10560780.0 | 25483750.0 | 15.0 | 309.0 | 397.633333 | 481.300000 | 4224312.0 | 10468051.0 | 5385390.0 | 15342035.0 | 10.0 | 159.0 | 99.530196 | 78.154236 | 4224312.0 | 5491605.5 | 20.433333 | 210000.0 | 5200320.0 | 5.0 | 9.0 | 20.433333 | 0.200000 | 4224312.0 | 515160.0 | ENTIDADES SEM FINS LUCRATIVOS | EDUCACAO | LESTE POTIGUAR | NATAL | EDUCACAO | 23.0 | 45.29 | 54.71 | 424.0 | 0.0 | NaN | NaN | NaN | NaN | 1.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 254.0 | 0.0 | 254.0 | 1 | 170.0 | 170.0 | 206.0 | 112.0 | 318.0 | 393.0 | 2.0 | 1.0 | 3.0 | 2.0 | NaN | 2.0 | NaN | 3.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | RN | RN | 10770780.0 | 170.0 | 20.0 | 0.000000 | -17.475728 | 0.000000 | 42500700.0 | 93862150.0 | 4224312.0 | 10983211.0 | 141655.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | 4.0 | 1.0 | 1.0 |
| 6 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2003-02-06 | 1811.66 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | False | NaN | NaN | 53.0 | 297.0 | 268.0 | 194e619cb6417f92f75653406cf04106debc5035f13a8850b00428fd34d91d72 | 216.0 | NaN | 5.0 | 15.0 | 43.0 | 42.0 | 29.0 | 51.0 | 78.0 | 139.0 | 15 a 20 | 15.734247 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 191.600000 | 467.233333 | NaN | NaN | NaN | NaN | NaN | NaN | 138.385891 | 126.687314 | NaN | NaN | 24.200000 | NaN | NaN | NaN | NaN | 24.200000 | 2.566667 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 49.35 | 50.65 | 896.0 | 0.0 | NaN | NaN | NaN | NaN | 3.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 277.0 | 0.0 | 278.0 | 0 | 619.0 | 619.0 | 690.0 | NaN | NaN | 618.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 618.0 | NaN | 0.000000 | -10.289855 | 0.000000 | 195554740.0 | 195554740.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 7 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ACIMA DE 1 ANO | VERDE | 2003-03-15 | 857.89 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 18.0 | 143.0 | 7.0 | cc734f72fdd8753ba2e7638f3d09e0597fd859735904dafab03cec6b347b331d | 3.0 | NaN | 10.0 | 26.0 | 34.0 | 38.0 | 28.0 | 18.0 | 7.0 | 4.0 | > 20 | 26.520548 | NaN | 63.0 | NaN | NaN | NaN | 63.0 | NaN | 63.0 | NaN | NaN | NaN | NaN | 274.300000 | 274.300000 | NaN | NaN | NaN | NaN | NaN | NaN | 44.566270 | 29.254984 | NaN | NaN | 2.433333 | NaN | NaN | NaN | NaN | 2.433333 | -0.600000 | NaN | NaN | OUTROS | ALIMENTACAO | CENTRO AMAZONENSE | MANAUS | ALOJAMENTO E ALIMENTACAO | 23.0 | 22.62 | 77.38 | 428.0 | 10.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 260.0 | 2.0 | 260.0 | 1 | 168.0 | 160.0 | 186.0 | NaN | NaN | 168.0 | NaN | NaN | 1.0 | NaN | NaN | 1.0 | NaN | 1.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | SERVIÇO | AM | AM | NaN | 168.0 | NaN | 5.000000 | -9.677419 | 1.219512 | 26994384.0 | 27924384.0 | NaN | NaN | 382387.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 5.0 | 5.0 |
| 8 | 61.333333 | NaN | 17.933333 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2010-05-20 | NaN | 19171824.0 | 19381824.0 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | 2.0 | NaN | 17.0 | 98.0 | 64.0 | 7e46107cb32e64f7f90ec16372d29f205f0d9781140308267f8c5d07b65a22fe | 6.0 | 5.0 | 10.0 | 36.0 | 40.0 | 43.0 | 19.0 | 11.0 | 7.0 | 4.0 | 5 a 10 | 8.446575 | 61.333333 | 41.0 | 32.544444 | 32.544444 | NaN | 40.0 | 17.933333 | 39.0 | 18751824.0 | 18961824.0 | 1.0 | 118.0 | 83.733333 | 83.733333 | 7500729.5 | 7500729.5 | 6390608.0 | 6460608.0 | 1.0 | 118.0 | 30.029853 | 18.908407 | 7500729.5 | 7500729.5 | 2.033333 | 210000.0 | 210000.0 | 1.0 | 118.0 | 2.033333 | -0.600000 | 7500729.5 | 7500729.5 | ENTIDADES EMPRESARIAIS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | VALE DO ACRE | RIO BRANCO | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 28.18 | 71.82 | 452.0 | 58.0 | NaN | NaN | NaN | NaN | 6.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 270.0 | 49.0 | 270.0 | 0 | 182.0 | 179.0 | 131.0 | 118.0 | 118.0 | 181.0 | 1.0 | 1.0 | 2.0 | 5.0 | NaN | 2.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AC | AC | 19171824.0 | 181.0 | 3.0 | 1.675978 | 38.931298 | 27.605634 | 35185428.0 | 35185428.0 | 7500729.5 | 7500729.5 | 559626.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11.0 | 11.0 | 1.0 | 1.0 |
| 9 | 116.133333 | NaN | 116.133333 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | VERDE | 2007-10-18 | 2346.09 | 23182200.0 | 23182200.0 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 15.0 | 117.0 | 16.0 | 2206453fbc92af65e47ce6ee2be27fa90ac427845ea0a539a1ab78df1388e7d2 | 1.0 | NaN | 23.0 | 41.0 | 21.0 | 26.0 | 16.0 | 11.0 | 7.0 | 2.0 | 10 a 15 | 11.035616 | 116.133333 | 64.0 | 116.133333 | 116.133333 | NaN | 49.0 | 116.133333 | 34.0 | 23182200.0 | 23182200.0 | NaN | 161.0 | 113.533333 | 113.533333 | 9272880.0 | 9272880.0 | 23182200.0 | 23182200.0 | NaN | 161.0 | 40.449775 | 21.582770 | 9272880.0 | 9272880.0 | 2.933333 | 23182200.0 | 23182200.0 | NaN | 161.0 | 2.933333 | -0.500000 | 9272880.0 | 9272880.0 | ENTIDADES EMPRESARIAIS | SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | NaN | NaN | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 23.0 | 61.49 | 38.51 | 978.0 | 29.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 830.0 | 50.0 | 830.0 | 0 | 148.0 | 167.0 | 220.0 | 161.0 | 161.0 | 148.0 | 1.0 | 1.0 | 2.0 | 1.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | RO | RO | 23182200.0 | 148.0 | NaN | -11.377246 | -32.727273 | 31.545741 | 22357944.0 | 22357944.0 | 9272880.0 | 9272880.0 | 248083.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 |
Last rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 255 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 3419.68 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 63.0 | 271.0 | 229.0 | 1ec76d8ef1d7c6bb73ef86a43d713725b1b610240bdf4a729cdd9ba076ad47a8 | 210.0 | 1.0 | 8.0 | 11.0 | 40.0 | 28.0 | 30.0 | 48.0 | 71.0 | 116.0 | 15 a 20 | 19.843836 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 490.433333 | 490.433333 | NaN | NaN | NaN | NaN | NaN | NaN | 180.181442 | 97.031514 | NaN | NaN | 3.466667 | NaN | NaN | NaN | NaN | 3.466667 | 1.800000 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 22.0 | 55.42 | 44.58 | 1484.0 | 6.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 920.0 | 8.0 | 920.0 | 0 | 564.0 | 566.0 | 615.0 | NaN | NaN | 563.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 563.0 | NaN | -0.353357 | -8.292683 | 1.415929 | 169642190.0 | 169642190.0 | NaN | NaN | 10151299.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 101.0 | 101.0 | 0.0 | 0.0 |
| 256 | 516.933333 | NaN | 39.733333 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS DE SAUDE | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 2348.34 | 3.915216e+06 | 3.915216e+06 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 12.0 | 91.0 | 42.0 | a3d4217a7c01f6cabd26d86cb283923c682a18d516f015e6f8b4796da8fef659 | NaN | NaN | 13.0 | 23.0 | 32.0 | 33.0 | 18.0 | 16.0 | 6.0 | 4.0 | 15 a 20 | 19.761644 | 516.933333 | 44.0 | 203.111111 | 203.111111 | NaN | 41.5 | 39.733333 | 39.0 | 2.843683e+06 | 2.843683e+06 | NaN | 13.0 | 121.600000 | 121.600000 | 947894.4 | 947894.4 | 1.305072e+06 | 1.305072e+06 | NaN | 7.000000 | 52.999543 | 40.757037 | 4.533408e+05 | 4.533408e+05 | 3.933333 | 329702.4 | 329702.4 | NaN | 4.0 | 3.933333 | 0.466667 | 164851.2 | 164851.2 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE ATENCAO A SAUDE HUMANA | CENTRO NORTE PIAUIENSE | TERESINA | SAUDE HUMANA E SERVICOS SOCIAIS | 23.0 | 69.66 | 30.34 | 270.0 | 14.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 124.0 | 9.0 | 124.0 | 3 | 146.0 | 141.0 | 166.0 | 21.0 | 21.0 | 145.0 | 3.0 | 1.0 | 2.0 | 4.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | PI | PI | 3.915216e+06 | 145.0 | NaN | 3.546099 | -12.048193 | 6.271777 | 24727680.0 | 28697680.0 | 1.360022e+06 | 1.360022e+06 | 182413.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.0 | 2.0 | 2.0 |
| 257 | 25.566667 | NaN | 25.566667 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2005-10-14 | 3021.53 | 2.100000e+05 | 2.100000e+05 | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | 1.0 | NaN | 73.0 | 122.0 | 5.0 | feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae | 2.0 | NaN | 19.0 | 28.0 | 46.0 | 35.0 | 27.0 | 19.0 | 16.0 | 9.0 | 15 a 20 | 16.769863 | 25.566667 | NaN | 25.566667 | 25.566667 | NaN | NaN | 25.566667 | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 92.233333 | 92.233333 | NaN | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 18.929612 | 8.896976 | NaN | NaN | 3.700000 | 210000.0 | 210000.0 | NaN | NaN | 3.700000 | -0.533333 | NaN | NaN | OUTROS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 4.98 | 95.02 | 983.0 | 230.0 | NaN | NaN | NaN | NaN | 5.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 777.0 | 186.0 | 774.0 | 0 | 206.0 | 152.0 | 119.0 | NaN | NaN | 201.0 | 1.0 | 1.0 | 1.0 | 1.0 | NaN | NaN | NaN | 1.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | SERVIÇO | MA | MA | 2.100000e+05 | 201.0 | NaN | 35.526316 | 73.109244 | 101.086957 | 31321728.0 | 31321728.0 | NaN | NaN | 85833.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.0 | 0.0 | 0.0 |
| 258 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL | MEDIA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2000-12-27 | 1359.01 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | False | NaN | NaN | 18.0 | 305.0 | 55.0 | efd51c8f53a5931f1778398c485a861169c99a40072d8f8c8005b90c2ccb7ee6 | 206.0 | NaN | 2.0 | 2.0 | 10.0 | 13.0 | 11.0 | 9.0 | 51.0 | 74.0 | 15 a 20 | 17.846575 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 607.633333 | 607.633333 | NaN | NaN | NaN | NaN | NaN | NaN | 353.954938 | 281.495431 | NaN | NaN | 37.266667 | NaN | NaN | NaN | NaN | 37.266667 | -0.266667 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO NORTE PIAUIENSE | TERESINA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 14.02 | 85.98 | 572.0 | 0.0 | NaN | NaN | NaN | NaN | 6.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 194.0 | 0.0 | 194.0 | 0 | 378.0 | 378.0 | 379.0 | NaN | NaN | 378.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | NaN | 378.0 | NaN | 0.000000 | -0.263852 | 0.000000 | 59810076.0 | 59810076.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 259 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-04-02 | 372.23 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | 15.0 | 305.0 | 33.0 | 120ecac76e64ace3880969e7a6c7a20ff116b94a411fd0b53216978136a7d85b | 23.0 | NaN | 2.0 | 5.0 | 35.0 | 44.0 | 92.0 | 60.0 | 61.0 | 31.0 | > 20 | 43.539726 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 501.066667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 181.592823 | 92.680587 | NaN | NaN | 2.500000 | NaN | NaN | NaN | NaN | 2.500000 | -5.100000 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | LESTE POTIGUAR | LITORAL NORDESTE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 52.12 | 47.88 | 977.0 | 9.0 | NaN | NaN | NaN | NaN | 18.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 624.0 | 0.0 | 624.0 | 1 | 353.0 | 344.0 | 564.0 | NaN | NaN | 353.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 353.0 | NaN | 2.616279 | -37.411348 | 0.000000 | 63313164.0 | 63313164.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 1.0 | 1.0 |
| 260 | 206.900000 | NaN | 27.166667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | COOPERATIVA | ALTA | SERVICOS FINANCEIROS | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 1365.70 | 1.462024e+07 | 1.779363e+07 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | False | NaN | NaN | NaN | 16.0 | 72.0 | b6966d868fb7976f993aca02fb667c9ae8f5ebf4d2e033182d67d119a6a3db13 | 5.0 | 2.0 | 6.0 | 24.0 | 18.0 | 21.0 | 2.0 | 6.0 | 2.0 | 2.0 | 15 a 20 | 18.980822 | 206.900000 | 52.0 | 126.222222 | 126.222222 | NaN | 52.0 | 27.166667 | 52.0 | 1.045775e+07 | 1.045775e+07 | 3.0 | 57.0 | 176.300000 | 218.200000 | 4183099.2 | 4183099.2 | 4.873414e+06 | 5.931209e+06 | 3.0 | 42.333333 | 51.353933 | 43.703509 | 2.088115e+06 | 2.617013e+06 | 2.266667 | 700617.6 | 3461875.2 | 3.0 | 26.0 | 2.266667 | -0.300000 | 350308.8 | 1730937.6 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE SERVICOS FINANCEIROS | NaN | NaN | ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS | 23.0 | 55.68 | 44.32 | 152.0 | 12.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 3.0 | 2.0 | 0.0 | 0.0 | 63.0 | 9.0 | 63.0 | 0 | 89.0 | 86.0 | 73.0 | 106.0 | 127.0 | 88.0 | 3.0 | 2.0 | 2.0 | 3.0 | NaN | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | 2.0 | SERVIÇO | RO | RO | 1.462024e+07 | 88.0 | 3.0 | 3.488372 | 21.917808 | 10.285714 | 23903424.0 | 23903424.0 | 6.264346e+06 | 7.851038e+06 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 261 | 158.600000 | NaN | 20.600000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS DE SAUDE | ACIMA DE 1 ANO | VERDE | 2002-11-16 | 2484.07 | 4.200000e+05 | 4.200000e+05 | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | 1.0 | NaN | 4.0 | 119.0 | 73.0 | 4a87a82771996c18afc68a17d139bd318d08fa3e5dcf9f8aea4ed92b8c76b5d1 | NaN | 6.0 | 20.0 | 46.0 | 44.0 | 34.0 | 23.0 | 12.0 | 8.0 | 4.0 | > 20 | 22.493151 | 158.600000 | 51.0 | 89.600000 | 89.600000 | NaN | 36.0 | 20.600000 | 27.0 | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 271.800000 | 271.800000 | NaN | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 63.100493 | 49.762882 | NaN | NaN | 2.533333 | 210000.0 | 210000.0 | NaN | NaN | 2.533333 | 0.600000 | NaN | NaN | ENTIDADES EMPRESARIAIS | ATIVIDADES DE ATENCAO A SAUDE HUMANA | CENTRO NORTE PIAUIENSE | TERESINA | SAUDE HUMANA E SERVICOS SOCIAIS | 25.0 | 68.02 | 31.98 | 414.0 | 27.0 | NaN | NaN | NaN | NaN | 4.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 211.0 | 30.0 | 210.0 | 3 | 203.0 | 206.0 | 243.0 | NaN | NaN | 224.0 | 2.0 | 1.0 | 4.0 | 5.0 | 1.0 | 2.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | 1.0 | SERVIÇO | PI | PI | 4.200000e+05 | 197.0 | NaN | -1.456311 | -16.460905 | 14.669927 | 30136860.0 | 33145394.0 | NaN | NaN | 447145.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 7.0 | 7.0 | 0.0 | 0.0 |
| 262 | 56.200000 | NaN | 56.200000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2006-02-01 | NaN | 9.300000e+05 | 9.300000e+05 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | False | NaN | NaN | 150.0 | 127.0 | 2.0 | f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de5891b7bafbd7fe7cfc | 34.0 | NaN | 6.0 | 21.0 | 26.0 | 45.0 | 41.0 | 43.0 | 44.0 | 19.0 | 10 a 15 | 12.745205 | 56.200000 | 49.0 | 56.200000 | 56.200000 | NaN | 41.0 | 56.200000 | 33.0 | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 5099.066667 | 5099.066667 | NaN | NaN | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 173.809677 | 61.097177 | NaN | NaN | 20.733333 | 930000.0 | 930000.0 | NaN | NaN | 24.700000 | -0.566667 | NaN | NaN | ENTIDADES EMPRESARIAIS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | CENTRO AMAZONENSE | MANAUS | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 63.44 | 36.56 | 981.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 702.0 | 8.0 | 702.0 | 0 | 279.0 | 287.0 | 296.0 | NaN | NaN | 279.0 | 1.0 | 1.0 | 2.0 | 1.0 | NaN | 2.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AM | AM | 9.300000e+05 | 279.0 | NaN | -2.787456 | -5.743243 | 2.826855 | 40955220.0 | 40955220.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 263 | 321.633333 | NaN | 10.366667 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | COOPERATIVA | ALTA | SEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDE | ACIMA DE 1 ANO | AZUL | 2003-11-08 | 2281.44 | 2.275368e+07 | 2.720860e+07 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 6.0 | 45.0 | 69.0 | 98448fefe3e358578fa643b63fcdcf4a3f2dcb496863f8eb7cc85a0f4036e511 | 3.0 | 7.0 | 9.0 | 22.0 | 22.0 | 21.0 | 12.0 | 12.0 | 6.0 | 6.0 | > 20 | 26.402740 | 321.633333 | 70.0 | 166.300000 | 166.300000 | NaN | 59.5 | 10.366667 | 45.0 | 2.107004e+07 | 2.552496e+07 | 4.0 | 72.0 | 286.333333 | 286.333333 | 8428018.0 | 10550477.0 | 3.792280e+06 | 4.534767e+06 | 3.5 | 36.500000 | 67.994215 | 55.208629 | 4.244919e+06 | 5.306148e+06 | 2.933333 | 123638.4 | 123638.4 | 3.0 | 1.0 | 2.933333 | 0.333333 | 61819.2 | 61819.2 | ENTIDADES EMPRESARIAIS | SEGUROS RESSEGUROS PREVIDENCIA COMPLEMENTAR E PLANOS DE SAUDE | VALE DO ACRE | RIO BRANCO | ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS | 23.0 | 70.83 | 29.17 | 282.0 | 18.0 | NaN | NaN | NaN | NaN | 1.0 | 6.0 | 6.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 6.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 6.0 | 0.0 | 0.0 | 0.0 | 5.0 | 0.0 | 0.0 | 5.0 | 1.0 | 0.0 | 0.0 | 161.0 | 11.0 | 160.0 | 5 | 121.0 | 114.0 | 109.0 | 59.0 | 73.0 | 319.0 | 4.0 | 2.0 | 4.0 | 6.0 | 1.0 | 3.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 4.0 | NaN | 3.0 | SERVIÇO | AC | AC | 2.275368e+07 | 120.0 | 7.0 | 6.140351 | 11.009174 | 9.361702 | 30033828.0 | 61489496.0 | 8.489837e+06 | 1.061230e+07 | 156585.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | 2.0 | 1.0 | 1.0 |
| 264 | 596.233333 | NaN | 16.700000 | NaN | DE R$ 300.000.000,01 A R$ 500.000.000,00 | DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | BOA | SOCIEDADE ANONIMA FECHADA | ALTA | INDUSTRIA DIGITAL | ACIMA DE 1 ANO | VERDE | 2008-01-14 | 5985.49 | 5.223031e+09 | 5.451955e+09 | False | True | False | False | True | False | False | False | False | True | SIM | True | False | False | False | True | False | NaN | NaN | 140.0 | 2447.0 | 563.0 | 251f454db948590c50df496ea83f76e2227e24a32c2814dd00b363fd77754e29 | 5.0 | 7.0 | 643.0 | 949.0 | 749.0 | 444.0 | 200.0 | 95.0 | 41.0 | 17.0 | 10 a 15 | 10.794521 | 596.233333 | 72.0 | 106.631111 | 106.631111 | NaN | 52.5 | 16.700000 | 35.0 | 5.150974e+09 | 5.372531e+09 | 275.0 | 1716.0 | 30.333333 | 146.600000 | 171568880.0 | 241816100.0 | 3.482021e+08 | 3.634637e+08 | 24.0 | 361.600000 | 23.341541 | 18.284345 | 3.669588e+07 | 5.131406e+07 | 3.433333 | 210000.0 | 210000.0 | 1.0 | 10.0 | 3.433333 | -0.466667 | 288489.6 | 288489.6 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAO | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | INFORMACAO E COMUNICACAO | 23.0 | 33.56 | 66.44 | 5340.0 | 465.0 | NaN | NaN | NaN | NaN | NaN | 15.0 | 15.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 15.0 | 0.0 | 0.0 | 8.0 | 1.0 | 0.0 | 0.0 | 0.0 | 10.0 | 0.0 | 15.0 | 0.0 | 0.0 | 4.0 | 1.0 | 0.0 | 10.0 | 3.0 | 2.0 | 0.0 | 0.0 | 2168.0 | 394.0 | 2162.0 | 6 | 3172.0 | 3186.0 | 3460.0 | 1229.0 | 1808.0 | 3787.0 | 7.0 | 4.0 | 5.0 | 28.0 | NaN | 4.0 | NaN | 5.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 4.0 | NaN | 5.0 | SERVIÇO | MA | MA | 5.223031e+09 | 3150.0 | 288.0 | -0.439422 | -8.323699 | 12.561773 | 459934850.0 | 560530400.0 | 1.834794e+08 | 2.565703e+08 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |